Forum Discussion

investigatorjon's avatar
investigatorjon
Regular Visitor
2 years ago
Solved

Quick Measure for distinct count total

Hello everyone,   Very new to Power BI desktop and PBI in general and wanted to get some insight on a simple problem that I have in regards to creating a quick measure that accurately counts the to...
Tips and Tricks
  • sevenhills's avatar
    sevenhills
    2 years ago

    If danextian solution does not work, (it should), try this!

    Difference is I speced out the distinct count measure inline. 

     

    Outcome Distinct Count =  
var _dc = CALCULATE( DISTINCTCOUNT(Table1[outcome]))

RETURN SUMX( VALUES(Table1[Report ID]), _dc)

      

danextian's avatar
danextian
Icon for Super User rankSuper User
2 years ago

Hi investigatorjon 

 

Try either of these:

=
SUMX (
    SUMMARIZE ( data, data[report id], "@count", [distinctcount measure] ),
    [@count]
)

=
SUMX ( VALUES ( data[report id] ), [distinctcount measure] )