Forum Discussion

pschnei's avatar
pschnei
Regular Visitor
9 years ago

How to SUM a DISTINCTCOUNT?

I have now counted my groupments but I need to get the SUM of my DISTINCTCOUNT

 

Registered_SW =
CALCULATE (
DISTINCTCOUNT ( table[Groupment Id] ),
FILTER ( table, table[Registration Status] <> Blank ()),
FILTER ( table, table[License status] = "Freeware" || table[License status]="Locally Managed" || table[License status]="To be classified")
)

 

The automatic Total is not correct as there is the distinct....

Thanks for your help!

 

 

 

 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    You will want to use SUMX to add them up, but... you will need to know what you are putting on "rows" of your visual.  I'm going to pretend it... um, the date?  

     

    Total Registered SW = SUMX(VALUES(Table[SomeDate]), [Registered_SW])