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 want to create a graph where I have the market share of 3 brands (values) and 10 countries (Axis).
The problem is that the % of grand total is made only one the filtered 10 countries but I want the total to be made on all countries on my database. Is it possible ?
Thanks a lot.
Solved! Go to Solution.
Finnaly found with this formula
% of Grand Total =
DIVIDE (
SUM ( Table1[Values] ),
CALCULATE ( SUM ( 'Table1'[Values] ), ALL ( 'Table1'[brands] ) )
)
Finnaly found with this formula
% of Grand Total =
DIVIDE (
SUM ( Table1[Values] ),
CALCULATE ( SUM ( 'Table1'[Values] ), ALL ( 'Table1'[brands] ) )
)
Please someone can help me ? I have the same problem with lines where I want to follow the MS evolution month by month but the percentage is not made on the total value.
This is the difference between what I want to get ( works on excel) and powerbi. Percentage are not the same.
Hi @likmalik ,
Can you share the formula where you are calculating the %'s. I will help you update it as per your requirement.
Regards,
Veena Shenolikar
Hello @veenashenolikar, thankyou ! Here is my measure and then I just show it as %of grand total with right click:
My Measure = CALCULATE(SUM(Sheet1[Column]), DATESBETWEEN(Sheet1[Date], DATE(2020,01,01),DATE(2020,12,31)))
@likmalik , Try a % measure like
My Measure = divide(My Measure = CALCULATE(SUM(Sheet1[Column]), DATESBETWEEN(Sheet1[Date], DATE(2020,01,01),DATE(2020,12,31))), CALCULATE(SUM(Sheet1[Column]), DATESBETWEEN(Sheet1[Date], DATE(2020,01,01),DATE(2020,12,31)), all(Sheet1)))
or
My Measure = divide(My Measure = CALCULATE(SUM(Sheet1[Column]), DATESBETWEEN(Sheet1[Date], DATE(2020,01,01),DATE(2020,12,31))), CALCULATE(SUM(Sheet1[Column]), DATESBETWEEN(Sheet1[Date], DATE(2020,01,01),DATE(2020,12,31)), allselected(Sheet1)))
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 |
---|---|
115 | |
101 | |
78 | |
76 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |