Percent of Total

[i820017]

I am trying to create an explicit measure for percent of total for 'Procedure Request Form'[Reason for Ticket Request].

Here is the DAX that I am using, and the output that it is yielding. (Each bar graph is 100%).

Can anyone tell me how I can fix this? I do not want to use an implicit measure.

[i820017]

Here is a screen shot of the data that I am looking at.

[vojtechsima]

@i820017 
Change the total calculation to something like this:

COUNTROWS(ALL(procedure request form))

[i820017]

When I used COUNTROWS(ALL(procedure request form)), this is what I got.

[vojtechsima]

@i820017 
but you changed the Numerator (so I am not sure what that is now).
Please if you could share a copyable dataset, I can create a custom made solution for you.

[i820017]

Here is a copyable dataset.

[vojtechsima]

@i820017 

% of Reasons = 

var reasons = COUNT('Reason for Ticket Request'[Reason])
Var Total = COUNTROWS(ALL('Reason for Ticket Request'))

return FORMAT(DIVIDE(reasons, Total), "Percent")

Here you go.
Also, please note, copyable means that I can copy the data into Power BI and I have the dataset, so it means something like this:
DateCategoryQuarter

01.03.2022	Media	1
01.02.2022	Media	1
01.02.2022	Media	1
01.02.2022	Media	1
01.01.2022	Media	1
01.12.2021	Media	4
01.12.2021	Media	4
01.12.2021	Media	4
01.03.2022	Sports	1
01.03.2022	Sports	1
01.01.2022	Sports	1
01.01.2022	Sports	1
01.11.2021	Sports	4
01.11.2021	Sports	4
01.11.2021	Sports	4
01.10.2021	Sports	4

[i820017]

That didn't work. Here is the output that I got.

[vojtechsima · Accepted solution]

@i820017 
I see the mistake there, you are using "ALL" filter wrong, you have to put a Table there not Column, modify it to: 

COUNTROWS(ALL('Procedure Request Form'))

[i820017]

This worked...Thanks!!

[vojtechsima]

@i820017 
You're welcome, if you could please kudo answers that helped you. Thank you

[vojtechsima]

Hi, @i820017 
That seems okay, could you please share a sample dataset (copyable), please?