Dividing 2 columns of a matrix visual

[Anonymous]

Below is matrix visual I have created with no. of req's per person.

(Both Delayed and Ontime are from the same column in the data).

I

I wanted to calculate the TAT% by dividing Delayed requests by total no. of req's. I have created a measure which worked fine and got the correct TAT%. But when i included this measure in the matrix visual, TAT% is showing up for each any every column of the matrix visual. See the below image.

Please help me out with this. TAT% should only be visible in grand total column.

[Fowmy · Accepted solution]

@Anonymous 

As of today, the feature you are looking for is not available in Power BI but it is in Excel with Pivot Tables Sets.
You can vote for that feature at https://ideas.powerbi.com/ideas/

To solve your problem, you can set it up in table visual. You need to create two additional measures for Delayed and Ontime.

Delayed = CALCULATE( SUM(Table9[TAT]), Table9[Reponse] = "Delayed")
--------------------------------
On Time= CALCULATE( SUM(Table9[TAT]), Table9[Reponse] = "Ontime")
--------------------------------
Delayed % = 
DIVIDE(
    [Delayed],
    CALCULATE( SUM(Table9[TAT]) , ALLSELECTED(Table9))
)

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn