Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello community,
I have a problem and I think it would be not so hard, but I haven't yet experience with this tool.
I have a Matrix with following elements (from the visualizations pane)
If I select one month, I have (say)
status | KO | OK | TOTAL | ||
month | october | ||||
customer | N | % | N | % | |
AAA | 20 | 20% | 80 | 80% | 100% |
But If I select more than one month (say two) I need to have that every month sum up at 100% in every subtotal. Instead, I obtain the percentage of grand total and that's not what I want..
THere is a Measure I could create to achieve this goal?
Thanks in advance!
Solved! Go to Solution.
You can try to create a measure like below:
Measure =
var current_ = DISTINCTCOUNT('Table'[ID])
var total_per_month = CALCULATE(DISTINCTCOUNT('Table'[ID]),ALLEXCEPT('Table','Table'[Month]))
return DIVIDE(current_,total_per_month)
User | Count |
---|---|
119 | |
65 | |
65 | |
56 | |
50 |
User | Count |
---|---|
177 | |
84 | |
70 | |
64 | |
54 |