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 , 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 below
But 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% |