Forum Discussion
% of Total by Week
Hey guys, I've been digging around the forums today to try and find a solution, but can't quite find what I'm looking for. I'm trying to make a sparkline of 3 categories of data and their "% ...
I need help in same kind of problem.
Here Column B is the correct calculation which is done by using built-in option to "show value as percentage of grand total", I need to create measure to get the same calculations, for which "D" I created using the dax-
DIVIDE(RETAIL_AUDIT_COMPETENCY_AUDITOR_DISTRIBUTION[Sum of No. of records],CALCULATE(SUM(RETAIL_AUDIT_COMPETENCY_AUDITOR_DISTRIBUTION[Column No. of records]),ALL(RETAIL_AUDIT_COMPETENCY_AUDITOR_DISTRIBUTION[WEEKDAY],RETAIL_AUDIT_COMPETENCY_AUDITOR_DISTRIBUTION[AUDIT_STATUS])))
but I am getting the incorrect value.
Note- B or D is calculated respective to Audit_Status and Weekday columns.
Solution to this is much appreciated.
but I am getting the incorrect value.
Note- B or D is calculated respective to Audit_Status and Weekday columns.
Solution to this is much appreciated.