Total of Distinct Values

[Anonymous]

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	1
5	January	X	1
6	January	Y	1
7	January	Y	1
8	January	Y	1
TOTAL			2

On colunm "Count" i'm using the measure:

Count = DISTINCTCOUNT('Table'[Type])

Now, all i need is count how many Type i have on Month, for exemple:

Month	Type	Count
January	X	5
January	Y	3
Total		8

And i don't know how to do it 😞

Somebody help me, please

Note: The original table, the column Type repeat inside the column ID

ID	Month	Type	Count
1	January	X	1
1	January	X	1
1	January	X	1
2	January	X	1
2	January	X	1
3	January	X	1
4	January	X	1
4	January	X	1
5	January	X	1
6	January	Y	1
7	January	Y	1
7	January	Y	1
7	January	Y	1
8	January	Y	1

Thats why i use the measure:

Count = DISTINCTCOUNT('Table'[Type])

[amitchandak · Accepted solution]

@Anonymous , Try like

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

[ryan_mayu]

@Anonymous 

Please try this

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