Calculate a measure differently base on the time period selected in a slicer

[Cado_one]

Hi all,

I face an issue with a measure that looks simple but gives me difficulties.

The measure's objective is to return the count of trips on power plants and the difficulty is that the database has changed last year so we have to calculate the measure in a different way :

• Before the 28/10/2020 : Count the distinct plant / day combinations
• After the 27/10/2020 : Sum the value already calculated in a column of the table

Here is my measure :

nbDeplacements =

VAR ALTAIR_Access = IF(MAX(gmao_BI[DebutInterBI])<DATE(2020,10,28), COUNTROWS(GROUPBY(gmao_BI,gmao_BI[LocalisationBI],gmao_BI[DebutInterBI])), 0)

VAR MASTEM_Access = IF(MAX(gmao_BI[DebutInterBI])>DATE(2020,10,27), SUM(gmao_BI[NbreAccesSite]), 0)

RETURN ALTAIR_Access + MASTEM_Access

The problem is when I select a time period in the slicer which starts before and ends after the 28/10/2020, the measure is taking the Maximum date into account and not the entire period so only the second VAR applies.

Does anybody knows a function or a turnaround that could help me with that case please ?

Thanks in advance.

Regards,

Cado

[amitchandak · Accepted solution]

@Cado_one , Based on what I got. Try a measure like

nbDeplacements =
VAR ALTAIR_Access = calculate(COUNTROWS(GROUPBY(gmao_BI,gmao_BI[LocalisationBI],gmao_BI[DebutInterBI])), filter(gmao_BI,gmao_BI[DebutInterBI]<DATE(2020,10,28)))+0
VAR MASTEM_Access = calculate(SUM(gmao_BI[NbreAccesSite]), filter(gmao_BI,gmao_BI[DebutInterBI]>DATE(2020,10,27)))+0
RETURN ALTAIR_Access + MASTEM_Access

[Cado_one]

It's perfect thanks !