Forum Discussion

Cactus26's avatar
Cactus26
Helper I
8 years ago
Solved

Count unique values

Hi,   I am struggling with creation of the measure which will be recalculated after the filters in report via slicers will be selected. I was able to get the same effect using calculated columns, ...
Need Help
  • AlbertoFerrari's avatar
    AlbertoFerrari
    8 years ago

    Hi,

     

    Something like this should work (did not test it, writing it blind)

    COUNTROWS ( 
    FILTER ( 
        VALUES ( Table[YourColumn] ),
        CALCULATE ( COUNTROWS ( Table ) = 1
     )
)

and 

COUNTROWS ( 
    FILTER ( 
        VALUES ( Table[YourColumn] ),
        CALCULATE ( COUNTROWS ( Table ) >= 3
     )
)


    Of course, by playing with the condition of FILTER, you can achievev different results. 


    Have fun with DAX!

    Alberto Ferrari
    http://www.sqlbi.com

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Try this

 

Measure 1

 

=COUNTROWS(FILTER(VALUES(Data[Data]),COUNTA([Data])=1))

Measure 2

 

=COUNTROWS(FILTER(VALUES(Data[Data]),COUNTA([Data])>=3))