Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
What I got after filtering NAME Column was that the % Total will be deducted from the row I filtered in Power BI Report. Is it possible to do what I attached. Thanks.
Solved! Go to Solution.
Hi @chaichatp,
Please try out these two measures.
% of Grand Total = DIVIDE ( SUM ( Table1[Quantity] ), CALCULATE ( SUM ( Table1[Quantity] ), ALLSELECTED ( Table1[Name] ) ), 0 )
%GrandTotal*Score = IF ( HASONEVALUE ( Table1[Name] ), [% of Grand Total] * MIN ( Table1[Score] ), SUMX ( SUMMARIZE ( 'Table1', Table1[Name], "score", [% of Grand Total] * MIN ( 'Table1'[Score] ) ), [score] ) )
Best Regards,
Dale
Hi @chaichatp,
Please try out these two measures.
% of Grand Total = DIVIDE ( SUM ( Table1[Quantity] ), CALCULATE ( SUM ( Table1[Quantity] ), ALLSELECTED ( Table1[Name] ) ), 0 )
%GrandTotal*Score = IF ( HASONEVALUE ( Table1[Name] ), [% of Grand Total] * MIN ( Table1[Score] ), SUMX ( SUMMARIZE ( 'Table1', Table1[Name], "score", [% of Grand Total] * MIN ( 'Table1'[Score] ) ), [score] ) )
Best Regards,
Dale
Wowww. That looks like what I was looking for. Thanks so much.
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |