Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
103 | |
76 | |
66 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
81 | |
68 |