row total percentage DAX

[Magpie_Rob]

Hello, 

I have a matrix with dates as rows and 'Customer Type' as columns, I'm trying to recreate the row total % as a DAX measure so I can change the formating from 2 decimal places to 0. 

I usually use ALLEXCEPT for the rows but I think this is ignoring the Column context (customer type) I tired added in another all except condition but this didn't help. 

I'm expecting the Dax % to be the same as %

Any help is greatly appreciated. 

Thanks 

Magpie

[v-luwang-msft]

Hi @Magpie_Rob ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[Magpie_Rob]

Hi, 

Please see sample pbix

Thank you! 

Rob

https://musicmagpie-my.sharepoint.com/:u:/g/personal/rob_thoms_musicmagpie_co_uk/ERDNcYtsSidHss8okMF...

https://musicmagpie-my.sharepoint.com/:u:/g/personal/rob_thoms_musicmagpie_co_uk/ERDNcYtsSidHss8okMF...

[v-luwang-msft]

Hi @Magpie_Rob ,

Try measure like below:

% of Total Measure = FORMAT( 
DIVIDE (
    CALCULATE ( SUMX ( 'Date Table',[Qty Customers] ) ),
    CALCULATE (
        SUMX( 'Date Table',[Qty Customers]),
        ALL ( 'Date Table'[Year], 'Date Table'[MonthName])
    ),
    0
),"percent")

Final get :

Best Regards

Lucien

[Certif_2022]

Excellent Example! I have the same issue, and this measure works excellent in my Report. Thanks!

[Magpie_Rob]

hi @v-luwang-msft  unfortunately this still isn't working - I'm going to upload a sample pbix shortly. 

[v-luwang-msft]

Hi @Magpie_Rob ，

To calculate the % for each item this is the dax sentence:

Since I do not have your specific data, I have made a relevant presentation on my data at,see the below:

% of Total Measure =
DIVIDE (
    CALCULATE ( SUM ( Table1[Sales] ) ),
    CALCULATE (
        SUM ( Table1[Sales] ),
        ALL ( Table1[Quarter], Table1[Item Description] )
    ),
    0
)

If question still not solved ,could pls share your pbix file?Remember to remove confidential data.

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Best Regards

Lucien

[amitchandak]

@Magpie_Rob , Try a measure like

calculate([Qty Customer], filter(allselected('Date Table'), 'Date Table'[Date] = max('Date Table'[Date])))