Hi, I have 2 matrix visuals, data like below and to find percentage from both matrix 1 & 2 and show % in matrix 3
Ticket Type high lowTicket statusopen 10 5close 15 7reopen 20 4
in above data group by Ticket type and ticket status with respect to id and created measure for totalnumbers=distinctcount(table[id])
Ticket Type high lowTicket statusopen 5 3close 2 4reopen 4 1
in above data group by Ticket type and ticket status and getting only closed tickets with decision takn as "Yes", created measure is
closeddecisiontickets=CALCULATE(DISTINCTCOUNT(table[ID]), FILTER(table, table[decision]= "yes"))+0
In Matrix 3 i would like to show percentage of both matrix 1 and matrix 2, here is my formula for percentage
percentage= closed decisiontickets/totalnumbers
Matrix 3 expected output
Ticket Type high% low%Ticket statusopen 50% 60%close 13.3% 58%reopen 20% 25%
for example individual matrix 2 values divided by matrix 1 values for example ( in matrix 2 close status value 2/matrix 1 status value 15). ( 2/15)=13.3%
so created measure ismeasure_percentage= (closed decisiontickets/totalnumbers) but i am not getting accurate % values
so please check and update correct measure or best approach to get matrix 3 expected output.
Thanks in advance for your help.
@Mahi1827 , create a common table Ticket Type /Status and the create these measures and analyze with help from common table
create measures like
Proud to be a Super User!
Your formulas seem correct. Share the link from where i can download your PBI file.
Hi @Mahi1827 ,
DAX measure are based on row context so any given value from slicers, filters, interactions with other visualizations, variables, relationships and so on can influence your result.
Please create a pbix using dummy data based on your data model and share the sample pbix via cloud service like onedrive for business.
Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.