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%...
that is the filter i am trying to apply. It is a measure
This is the formula for the entire table:
Grade % =
VAR TotalWeight =
CALCULATE(
SUMX(
'PRODUCTION- Results','PRODUCTION- Results'[Total Weight])
)
VAR GradeTypeTotalWeight =
CALCULATE(
SUMX(
'PRODUCTION- Results','PRODUCTION- Results'[Total Weight]),
REMOVEFILTERS('PRODUCTION- Results'[Grade Type])
)
RETURN
DIVIDE(
TotalWeight,
GradeTypeTotalWeight
)