I created my first Power BI report and dashboard. Woohoo! However, I cannot get my bar charts to calculate percentages based on column totals which includes two filters-fiscal year and subprogram. I tried to creating a new measure with a DAX expression that uses AllExcept. It calculates the fiscal year filter when I don’t add subprogram but I cannot get it to calculate with the subprogram filter.
Here is expression: Percentage = COUNT(‘akoya_request’[Request #])/CALCULATE(COUNT(akoya_request[Request #]),ALLEXCEPT(‘akoya_request’,‘akoya_request’[Fiscal Year], akoya_request[SubProgram]))
Any suggestions are greatly appreciated.