Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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])
Solved! Go to Solution.
@Anonymous , Try like
sumx(summarize(Table,Table[month],table[Type],"_1",DISTINCTCOUNT('Table'[ID])),[_1])
@Anonymous , Try like
sumx(summarize(Table,Table[month],table[Type],"_1",DISTINCTCOUNT('Table'[ID])),[_1])
@Anonymous
Please try this
Measure 3 = CALCULATE(DISTINCTCOUNT(Sheet8[ID]),ALLEXCEPT(Sheet8,Sheet8[ID],Sheet8[Month],Sheet8[Type]))
Proud to be a Super User!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |