DAX Function Guide

COMBINA
Empty image or helper icon

Sam McKay

CEO & Founder

How does the COMBINA work?
The COMBINA function (DAX) is a math and trigonometry function that returns the number of combinations (with repetitions) for a given number of items.
COMBINA Formula Syntax

COMBINA(
     number, number_chosen
)

How do you use the COMBINA?

This function is used to calculate the number of combinations (with repetitions) of a given number objects from a set.

Related Blog Posts

Loading

Considerations when using the COMBINA?

If the value of either argument is outside of its constraints, COMBINA returns a #NUM! error message. If either of the argument is non-numeric, the function will return the #VALUE! error.

Related Video Tutorials

Loading

Formula examples using the COMBINA

=COMBINA(4,3)

=COMBINA(10,3)

=COMBINA(21, 5)

Related Courses

Loading