Forum Discussion

superDAX's avatar
superDAX
Frequent Visitor
6 years ago

Distinct count subtotal

Hello All    I am a newbie to Dax !,   The answer to my query is likely very simple    I have performed a distinct count on all values in a column which are higher than zero    However, the p...
Need Help
superDAX's avatar
superDAX
Frequent Visitor
6 years ago

Hi amitchandak 

 

Thank you for replying 

 

I have used a measure to get the distinct count , i tried changing the original columns format to general but the measures subtotal still shows only 1 ?

amitchandak's avatar
amitchandak
Super User
6 years ago

One top of count distinct, you need to have sum. In case it is number use base column to get distinct count

  • superDAX's avatar
    superDAX
    Frequent Visitor
    6 years ago

    Hi amitchandak 

     

    How would you write this into the measure? , currentlu the measure is CALCULATE(DISTINCTCOUNT(Table1[Forecast Reviewed]),FILTER(Table1,[Forecast Reviewed]>0))

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      I am not sure on the values in [Forecast Reviewed], based on the values it can sum, count distinct or we need to take count distinct of name

       

      CALCULATE(sum(Table1[Forecast Reviewed]),FILTER(Table1,[Forecast Reviewed]>0))

       

      CALCULATE(DISTINCTCOUNT(Name]),FILTER(Table1,[Forecast Reviewed]>0))