Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have 2 matrix visuals, data like below and to find percentage from both matrix 1 & 2 and show % in matrix 3
Matrix 1
---------
Ticket Type high low
Ticket status
open 10 5
close 15 7
reopen 20 4
in above data group by Ticket type and ticket status with respect to id and created measure for totalnumbers=distinctcount(table[id])
Matrix 2
---------
Ticket Type high low
Ticket status
open 5 3
close 2 4
reopen 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 status
open 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 is
measure_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.
Thanks,
Mahi1827
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,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Your formulas seem correct. Share the link from where i can download your PBI file.
@Mahi1827 , create a common table Ticket Type /Status and the create these measures and analyze with help from common table
create measures like
divide(sum(Matrix1[high]),sum(Matrix2[high]))
divide(sum(Matrix1[low]),sum(Matrix2[low]))
https://www.youtube.com/watch?v=Bkf35Roman8
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |