Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculating quarter data based on the month slicer selection

Hi All, I have a scenerio where i need to calculate the total sum of a measure for the current quarter but the problem is there is an report level filter which is MONTH So the requirement is when a...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Prabin,

     

    Filter the scope with calculating the quarter of the selected month from slicer like below:

     

    CALCULATE(SUM('C&SB'[Actual]),FILTER(ALL('Date Dimension'),'Date Dimension'[Quarter]=ROUNDUP(SELECTEDVALUE('Date Dimension'[MonthN])/3,0)))
     
    Quarter & MonthN are numbers respectively.
     
    Hope it helps.
     
    Cheers,
    Amit
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Prabin,

 

Filter the scope with calculating the quarter of the selected month from slicer like below:

 

CALCULATE(SUM('C&SB'[Actual]),FILTER(ALL('Date Dimension'),'Date Dimension'[Quarter]=ROUNDUP(SELECTEDVALUE('Date Dimension'[MonthN])/3,0)))
 
Quarter & MonthN are numbers respectively.
 
Hope it helps.
 
Cheers,
Amit
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Amit,

It was really helpful 

Thanks
Prabin Nepak