Forum Discussion
bhmiller89
Helper V
Helper VCalculate Percentage value based on Slicer Selection
I have a list of Job Numbers and columns that determine whether a job meets any of 5 criteria (let's call them Criteria1-5) I need to create a pie chart or even just a data card that shows what p...
BILASolution
Solution Specialist
Solution SpecialistHi bhmiller89
To solve your answer...
1. Data Sample (In my case, the table is called "Table 1")
2. Create the next measures...
Total Jobs = CALCULATE(DISTINCTCOUNT(Table1[Job Number]);ALL(Table1))
Total Criteria = DISTINCTCOUNT(Table1[Job Number])
Percentage = DIVIDE([Total Criteria];[Total Jobs])
3. The results look like...
I hope this helps
Regards
BILASolution