Forum Discussion

houssamedd's avatar
houssamedd
New Member
7 years ago
Solved

DISTINCT COUNT AND GROUP BY

Good morning Power BI community! I have been running through some problems creating the correct measure, and I'm wondering if you guys can help.   I have a table that goes like this: I crea...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi houssamedd,

     

    Try this formula, please. BTW, the first need doesn't need a measure. Try the built-in calculation.

    Measure =
CALCULATE (
    DISTINCTCOUNT ( Table1[Book] ),
    ALLEXCEPT ( Table1, Table1[publishing house] )
)

    DISTINCT-COUNT-AND-GROUP-BY

    Best Regards,
    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi houssamedd,

 

Try this formula, please. BTW, the first need doesn't need a measure. Try the built-in calculation.

Measure =
CALCULATE (
    DISTINCTCOUNT ( Table1[Book] ),
    ALLEXCEPT ( Table1, Table1[publishing house] )
)

DISTINCT-COUNT-AND-GROUP-BY

Best Regards,
Dale

  • houssamedd's avatar
    houssamedd
    New Member
    7 years ago

    Perfect, this worked.

    Thank you Dale!