CY vs PY in Time Series Chart Using Calc Groups

[Anonymous]

So I'm playing around with calculation groups and they seem good but I've hit a barrier. I want to display a single measure split into CFY and PFY shown as two lines on the same time series chart. The only way I've found of being able to do this is to create two explicit measures using my time intelligence calc group as a filter like so for CFY:

Sales CFY = COALESCE(
CALCULATE([Sales],
'Time Intelligence'[Time Segmentation] = "CFY"), 0
)

And then the same for PFY. I need to do this for multiple measures though which seems to negate the benefit of calc groups as it means repetition of the same measure definitions across all my measures. Am I missing something or is this a current limitation of calc groups? Thanks in advance!

[Sahir_Maharaj]

Hello @Anonymous,

Can you please try: 

Sales Measure = SELECTEDMEASURE()

Sales CFY = 
CALCULATE(
    [Sales Measure],
    'Time Intelligence'[Time Segmentation] = "CFY"
)

Sales PFY = 
CALCULATE(
    [Sales Measure],
    'Time Intelligence'[Time Segmentation] = "PFY"
)

Hope this helps.

[Anonymous]

Hi Sahir,

Thanks for this and I see where you're going but the DAX provided doesn't appear to be valid and results in an error. I think also, you'd need a slicer to switch between the two selected measures. I already have another calculation group that enables this switch functionality but it only allows one measure/Calculation item in the time series chart at one time. I'm wanting to have both the CFY and PFY as two separate lines as if they were two independent measures. But just using a combination of a single measure and two calculation items.

After looking into this, I suspect it's not possible tbh. Let me know if I've misunderstood though!

Thanks,

Luke