cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NourJ Regular Visitor
Regular Visitor

Quarter calculation

 

Dear Community,

 

i want to display the quarter in card the rows number is the right number but i dont know what is this number or from where is coming

 

this is the measure i used

the quarter = SUMX(ALLEXCEPT(Append1,Append1[quarter no 1]),[IDP Arrived IND 2018+2019])
 
thank you in advance
 

Capture.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Quarter calculation

Hi @NourJ ,

 

To create a measure as below.

 

the quarter = var q = MAX(Append1[quarter no 1])
return
CALCULATE(SUM(Append1[IDP Arrived IND 2018+2019]),FILTER(ALL(Append1),Append1[quarter no 1]=q))

Capture.PNG

 

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

Re: Quarter calculation

Hi @NourJ ,

 

To create a measure as below.

 

the quarter = var q = MAX(Append1[quarter no 1])
return
CALCULATE(SUM(Append1[IDP Arrived IND 2018+2019]),FILTER(ALL(Append1),Append1[quarter no 1]=q))

Capture.PNG

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
NourJ Regular Visitor
Regular Visitor

Re: Quarter calculation

great, thank you so much.