cancel
Showing results for
Did you mean:
Helper I

## Percent based on qtr instead of grand total

All,

I am attempting to calculate the percent of 3 different groups in a single qtr for the current ytd.  Unfortunately, the calculation only does grand total.  Is there a way to calculate based on qtr.  Sample of table below

 Closed Date Time To Close 4/26/2016 >30 days 4/19/2016 >30 days 6/6/2016 <14 days 1/25/2016 <14 days 2/23/2016 <14 days 1/26/2016 <14 days 6/27/2016 14-30 days 7/8/2016 14-30 days 7/8/2016 14-30 days 7/4/2016 14-30 days
1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft

## Re: Percent based on qtr instead of grand total

Do you want to do the calculation like below?

If that is the case, you need to add a calculated column named "Qtr":

Qtr = 'Percent'[Closed Date].[Quarter]

Create three measures to get the percentage value:

CountRowsOfQrt = CALCULATE(COUNTROWS('Percent'),ALLEXCEPT('Percent','Percent'[Qtr]))
CountRowsOfQrtandTime = CALCULATE(COUNTROWS('Percent'),ALLEXCEPT('Percent','Percent'[Qtr],'Percent'[Time To Close]))

Percentage = [CountRowsOfQrtandTime]/[CountRowsOfQrt]

If I have something misunderstood, please describe more clear about how to calculate the percentage and you can port some screenshots of your expect result.

Thanks,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Microsoft

## Re: Percent based on qtr instead of grand total

Do you want to do the calculation like below?

If that is the case, you need to add a calculated column named "Qtr":

Qtr = 'Percent'[Closed Date].[Quarter]

Create three measures to get the percentage value:

CountRowsOfQrt = CALCULATE(COUNTROWS('Percent'),ALLEXCEPT('Percent','Percent'[Qtr]))
CountRowsOfQrtandTime = CALCULATE(COUNTROWS('Percent'),ALLEXCEPT('Percent','Percent'[Qtr],'Percent'[Time To Close]))

Percentage = [CountRowsOfQrtandTime]/[CountRowsOfQrt]

If I have something misunderstood, please describe more clear about how to calculate the percentage and you can port some screenshots of your expect result.

Thanks,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper I

## Re: Percent based on qtr instead of grand total

Thanks this helped, but found a limitation if I use a slicer.  When i filter the report the slicer calculates percentage incorrectly since the slicer impacts the total count.  Is there a way around this?

Announcements

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

#### April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors