Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I searched the forum not able to find the solution for below. The dataset has top defects types, I can show each type of defects as count but I want to also show these (each defect type) count of total defect type out of the total defect count. This is text field not able to find a solution for this.
e.g. in below for Ticket idle % will 3/ 6*100 = 50 %
Please help
Solved! Go to Solution.
Hi @prady2581
Two methods
1.
2. create a measure
Measure = DIVIDE ( CALCULATE ( COUNT ( Sheet4[ticket] ), ALLEXCEPT ( Sheet4, Sheet4[gap reasons] ) ), CALCULATE ( COUNT ( Sheet4[ticket] ), ALL ( Sheet4 ) ) )
Best Regards
Maggie
Hi @prady2581
Two methods
1.
2. create a measure
Measure = DIVIDE ( CALCULATE ( COUNT ( Sheet4[ticket] ), ALLEXCEPT ( Sheet4, Sheet4[gap reasons] ) ), CALCULATE ( COUNT ( Sheet4[ticket] ), ALL ( Sheet4 ) ) )
Best Regards
Maggie
try to add measure
new measure = divide(count([Gap Reasons]);countx(All([Gap Reasons]);[Gap Reasons])
thanks! this a good solution.
One additional problem: how could the expression be written in order to also consider a specific period of time in the dataset?
For example, my dataset is broken down by month and, when I filter in my visualizations by a specific month, the percentages don't change because the expression is considering the full dataset.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |