Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Total of Distinct Values

Hello all!   I'm new on Power BI and i have the follow issue:   I have the table below: ID Month Type Count 1 January X 1 2 January X 1 3 January X 1 4 January X ...
General Comment
Interesting Links
Need Help
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Try like

    sumx(summarize(Table,Table[month],table[Type],"_1",DISTINCTCOUNT('Table'[ID])),[_1])

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
6 years ago

Anonymous 

 

Please try this

Measure 3 = CALCULATE(DISTINCTCOUNT(Sheet8[ID]),ALLEXCEPT(Sheet8,Sheet8[ID],Sheet8[Month],Sheet8[Type]))