Forum Discussion
Add Row Showing % of Current Column
Hi,
Your 'Sum of Total' is aggregated by Power BI automatically. You will need to make a few Explicit Measures by creating 'New Measures', in your case they would be
Total = SUM('Vlookup - Exact'[Total])
Total Spend =
CALCULATE (
[Total],
ALL ( 'Vlookup - Exact'[Region] ), ALL ( 'Vlookup - Exact'[Month] )
)% of Spend Grand Total =
IF (HASONEVALUE( 'Vlookup - Exact'[Region] ),
BLANK(),
DIVIDE ( [Total], [Total Spend] )
)For the rest of steps, use 'Total' and '% of Spend Grand Total' Measures for your 'Values' in Matrix visual.
Hi,
Your 'Sum of Total' is aggregated by Power BI automatically. You will need to make a few Explicit Measures by creating 'New Measures', in your case they would be
Total = SUM('Vlookup - Exact'[Total])
Total Spend =
CALCULATE (
[Total],
ALL ( 'Vlookup - Exact'[Region] ), ALL ( 'Vlookup - Exact'[Month] )
)
% of Spend Grand Total =
IF (
HASONEVALUE( 'Vlookup - Exact'[Region] ),
BLANK(),
DIVIDE ( [Total], [Total Spend] )
)
For the rest of steps, use 'Total' and '% of Spend Grand Total' Measures for your 'Values' in Matrix visual.
Thanks you very much for this. The formatting now works, of course, however I am getting 100% for all figures. I'll take a look when I get a chance and see if I can work out what's happening. It's likely something I've done.
thanks again
And yes, it was me that made a mistake, used the wrong version of Month, now works.
Thank you!