Create a measure to calculate all 4 quarters

[jonnyA]

Hi, I am trying to create a measure that will sum all 4 quarters.

The following measure was created to calculate the total # of "Patients" for Quarter 1 ...

Patients Qtr 1 =

CALCULATE (

( Charge_Dataset[Patients] ),

FILTER ( '_Charge_Dataset', Quarter(_Charge_Dataset[DOS])= 1 ))

Is there a way to tweak this measure so it calculated all 4 quarters?

Thank you!

[jonnyA]

@v-lionel-msft , 

Thank you for the measure, however, neither worked.  Here are the results that came back with the second measure you gave me, which i renamed "Total Quarters" ("Total Quarters" on the matrix)

[v-lionel-msft]

Hi @jonnyA ,

It seems that adding this formula directly to the matrix can complete the aggregation of each level.

Patients = SUM(Charge_Dataset[Patients])

 Or try this.

Patients =
CALCULATE (
( Charge_Dataset[Patients] ),
FILTER ( '_Charge_Dataset', Quarter(_Charge_Dataset[DOS])in {1,2,3,4} ))

 If they're useless, please provide a sample .pbix file(remove sensitive information.).

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jonnyA]

@v-lionel-msft ,

I feel like this measure is so close, however, it is still not correct.  Have any advice on how I can make this work? 

Patients 2 = CALCULATE ( (Charge_Dataset[Total Patients] ), FILTER ( 'Charge_Dataset', Quarter(Charge_Dataset[DOS])in {1,2,3,4} ))

[jonnyA]

@Ashish_Mathur , See screen shot below, the total should be 4075 ... not 4073.

I created quick measures to add quarters 1 and 2.  Then another quick measure add quarters 3 and 4.  Finally, I created another quick measure to add the Sum of Quarters 1 and 2 + the sum of quarters 3 and 4.  

Total Patients =

[Patients Qtr 1 plus Patients Qtr 2] + [Patients Qtr 3 plus Patients Qtr 4]

[Ashish_Mathur]

Hi,

I answered your question here - Re: My Total is not summing correctly - Microsoft Power BI Community

[Ashish_Mathur]

Hi,

Share some data, explain the question and show the expected result.