cancel
Showing results for
Did you mean:
Highlighted
Helper III

## How to get percentage from measures which are fetching from 2 different matrix values

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,

Mahi1827

3 REPLIES 3
Highlighted
Super User IV

@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]))

Proud to be a Super User!

Highlighted
Super User III

Hi,

Regards,
Ashish Mathur
http://www.ashishmathur.com
Highlighted
Microsoft

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.

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors