Forum Discussion
Need help :DAX Measure
I have a sum Of Sales DAX measure in Power bi. I want show the Sales Share by Sales Sub region and Destination Office wise as Below.It should show 100% in row wise like below Sales 2024 share De...
Thank you bhanu_gautam .
but we shoud take 100% for every Sub region row
But It shows Like belowBut we need Like below
Sales 2024 share Destin 1 Destin 2 Destin 3 Destin 4 Destin 5 Destin 6 Destin 7 Destin 8 Destin 9 Destin 10 Total Sales subreg 1 17% 1% 10% 10% 12% 10% 10% 10% 10% 10% 100% Sales subreg 2 15% 1% 12% 9% 10.00% 29% 10% 1% 3% 10% 100% Sales subreg 3 15% 11% 10% 9% 10% 10% 9% 8% 10% 8% 100%
Anonymous, Can you paste workable format of DAX rather than image
bhanu_gautam Here the DAX FUnction
Share % =
Share % =
DIVIDE(
SUM('TMR-Prev year'[ACTUAL_GROSS_SALE]),
CALCULATE(
SUM('TMR-Prev year'[ACTUAL_GROSS_SALE]),
REMOVEFILTERS('TMR-Prev year'[DESTINATION_OFFICE_KEY], 'TMR-Prev year'[SALES_OFFICE_KEY]) -- Adjust column names
),
0
)
Anonymous , Try using
DAX
Sales Share % =
DIVIDE(
SUM('TMR-Prev year'[ACTUAL_GROSS_SALE]),
CALCULATE(
SUM('TMR-Prev year'[ACTUAL_GROSS_SALE]),
ALLEXCEPT('TMR-Prev year', 'TMR-Prev year'[SALES_SUBREGION_KEY])
),
0
)Thank you bhanu_gautam .
but we shoud take 100% for every Sub region row
But It shows Like belowBut we need Like below
Sales 2024 share Destin 1 Destin 2 Destin 3 Destin 4 Destin 5 Destin 6 Destin 7 Destin 8 Destin 9 Destin 10 Total Sales subreg 1 17% 1% 10% 10% 12% 10% 10% 10% 10% 10% 100% Sales subreg 2 15% 1% 12% 9% 10.00% 29% 10% 1% 3% 10% 100% Sales subreg 3 15% 11% 10% 9% 10% 10% 9% 8% 10% 8% 100%