Forum Discussion
SelflearningBi
3 years agoHelper III
Total and row is different
How come the total is 76.82% but each row is 100%?
SelflearningBi , You need measure like
divide(Count(Table[OTIF]), calculate(Count(Table[OTIF]), filter(allselected(Table), Table[OTIF] = max(Table[OTIF])) ) )
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
1 Reply
- amitchandakSuper User
SelflearningBi , You need measure like
divide(Count(Table[OTIF]), calculate(Count(Table[OTIF]), filter(allselected(Table), Table[OTIF] = max(Table[OTIF])) ) )
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho