Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
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
Excellent Example! I have the same issue, and this measure works excellent in my Report. Thanks!
hi @v-luwang-msft unfortunately this still isn't working - I'm going to upload a sample pbix shortly.
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
@Magpie_Rob , Try a measure like
calculate([Qty Customer], filter(allselected('Date Table'), 'Date Table'[Date] = max('Date Table'[Date])))
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |