Forum Discussion
Power Bi Visual Help
I have created a visual on power bi and the results equal 100%- which is expected. However, once I add my filter (that is a measure), and apply this filter, i am getting results that equal up to 150%...
This is the measure I am using:
%ofGrade1&2 Test =
VAR Sumof12 =
CALCULATE(
[Total Weight Produced],
'PRODUCTION- Results'[Grade Type] = "1" ||
'PRODUCTION- Results'[Grade Type] = "2")
VAR TotalLbs=
CALCULATE(
SUM('PRODUCTION- Results'[Total Weight]),
ALL('PRODUCTION- Results'[Grade Type])
)
RETURN
CALCULATE(
DIVIDE(
Sumof12,
TotalLbs
)
)
I am hoping for it to evaluate Grade 1 and 2 combined, and only populated results where Grade1+Grade2=less than 50%
What is the slicer column?