Forum Discussion
BieBel
Helper I
Helper IPower Query calculate percentage for specific year
I have a ticketing system (data table 'output-tickts') and I want to calculate what % of the tickets was created in each year. My calculated % is OK if I I take all data into account (total = 100%) b...
Hi BieBel
Do you mean that the total amount you want to account for means the total amount of screening? Let's say for 2021, what do you want to show is output-tickets' [IA] as a percentage of the 2021 total? If so, you can refer to the following measures
%OfRequests = VAR Tickets = SUM ( 'output-tickets'[IA] ) VAR AllTickets = SUMX ( ALLSELECTED( 'output-tickets' ), 'output-tickets'[IA] ) RETURN DIVIDE ( Tickets, AllTickets )Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BieBelHelper I
Helper II'm not quite where I want to be :-(. Probably dit not I will search the forum a bit further/deeper. I may not have described the expected outcome accurately enough.
Thanks!