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%. Does anyone know why this may be?
7 Replies
- Arul
Super User
Anonymous ,
I think there is something wrong with your measure. Can you share the formula and the expected output?
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]))RETURNCALCULATE(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%- Arul
Anonymous ,
What is the slicer column?
- Arul
Anonymous ,
Which filter do you apply?
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]))RETURNDIVIDE(TotalWeight,GradeTypeTotalWeight)Hi Arul ,Thanks for your quick reply, I will add more.
Hi Anonymous ,
Regarding your question, please provide simple data and show your expected results as a picture. Or provide a .pbix file without sensitive data.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Wenbin Zhou
