Parallel Period - Multiple Quarter Selection

[Anonymous]

Hello everyone,

I'm facing some issues with slicer filtering on my visuals. I have a DAX formula for calculating the SLA% for the last Quarter:

L_Quarter SLA % FTF = CALCULATE([SLA % FTF], PARALLELPERIOD(dim_calendar[Date], -1, QUARTER))

When I add this to a KPI card in the  "target" field it displays correctly when I select multiple quarters in the current year:

Year selected: 2022

Quarters selected: Q1+ Q2 + Q3

In my measure I want to show the quarter before the quarter we are currently in. (for example: We are in 2022 Q4, I have the slicer selection as shown above, I want to display the value of 2022 Q3) this happens when I only select Q4 in my slicer, but it fails when I select multiple quarters. (So in the picture down below: "Last Quarter: 0.89" should be "100", the exact same measure is used, only the correct value is in the KPI card and the incorrect value with exact same measure in a normal "Card".)

Somehow, the KPI card, shows the correct output when multiple quarters are selected, but I need it in a measure.

Is there someone who knows a fix for this?

(can't share the pbix file)

[amitchandak]

@Anonymous , Make sure dim_calendar is marked as date table, has all dates, and join in single directional.

Try like

L_Quarter SLA % FTF = CALCULATE([SLA % FTF], dateadd(dim_calendar[Date], -1, QUARTER))

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[Anonymous]

This gave me the exact same output, when I use another calculation with SAMEPERIODLASTYEAR, it shows correctly, so I dont think there is something wrong with my data model.