Forum Discussion

bhmiller89's avatar
bhmiller89
Icon for Helper V rankHelper V
8 years ago
Solved

Calculate 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...
Need Help
BILASolution's avatar
BILASolution
Icon for Solution Specialist rankSolution Specialist
8 years ago

bhmiller89

 

This way???

 

 

 

Total Jobs = CALCULATE(DISTINCTCOUNT(Job[Job Number]);ALL(Job)) 
Total Criteria = CALCULATE(DISTINCTCOUNT(Job[Job Number]);Job[Value] = "Yes") 
Precentage = DIVIDE([Total Criteria];[Total Jobs])

Best Regards

BILAsolution

bhmiller89's avatar
bhmiller89
Icon for Helper V rankHelper V
8 years ago

BILASolution

 

 

not quite, I have columns written for each. Example: the column is titled "Criteria 1" and the values are either "Yes" or "No" based on an If/Then statement. I did it this way for each Criteria.  

 

Job Number| Criteria 1| Criteria 2|Criteria 3| .......

_____________________________________________________

XXX-XXX| "Yes"| "No"| "Yes"......