Forum Discussion
SelflearningBi
Helper III
Helper IIITotal 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
- amitchandak
Super 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