Dividing 2 columns of a matrix visual

Anonymous — Sat, 19 Dec 2020 14:11:54 GMT

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 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.

Re: Dividing 2 columns of a matrix visual

Fowmy — Sat, 19 Dec 2020 16:26:31 GMT

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

topic Dividing 2 columns of a matrix visual in DAX Commands and Tips

Dividing 2 columns of a matrix visual

Re: Dividing 2 columns of a matrix visual