Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm trying to have a Card visual in my report that has the average percent of GM across all products. I currently have a measure that calculates GM. How can I have the Card visual show the average? Do I have to create a new measure? Or should it already be showing the average by default? Thank you for your help.
% GM = ((SUM(SAPdata[Total Revenue NBT])-
SUM(SAPdata[Cost Sales Total]))/
SUM(SAPdata[Total Revenue NBT]))
Best.
Solved! Go to Solution.
Hi @espinozan,
If there is no any Slicers/Filters applied on your report, then the formula you provided above will calculates GM across all products. Or it will be calculated under the selected data.
To ignore all filters, and always calculates GM across all products, the formula below is for your reference.
% GM = CALCULATE ( DIVIDE ( SUM ( SAPdata[Total Revenue NBT] ) - SUM ( SAPdata[Cost Sales Total] ), SUM ( SAPdata[Total Revenue NBT] ) ), ALL ( SAPdata ) )
Regards
Hi @espinozan,
If there is no any Slicers/Filters applied on your report, then the formula you provided above will calculates GM across all products. Or it will be calculated under the selected data.
To ignore all filters, and always calculates GM across all products, the formula below is for your reference.
% GM = CALCULATE ( DIVIDE ( SUM ( SAPdata[Total Revenue NBT] ) - SUM ( SAPdata[Cost Sales Total] ), SUM ( SAPdata[Total Revenue NBT] ) ), ALL ( SAPdata ) )
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |