Forum Discussion

joshl525's avatar
joshl525
Frequent Visitor
10 months ago
Solved

Using two filters with a conditional

Hello, guys, 

 

I was trying to move from this measure =CALCULATE(SUM(BD_Core[Valor]),BD_Core[Versión]="Ppto V2")

to this: 

CALCULATE( SUM(BD_Core[Valor]), FILTER( BD_Core, ( BD_Core[year] = 2025 && BD_Core[Versión] = "Ppto V2" ) || ( BD_Core[year] <> 2025 && BD_Core[Versión] = "VP" ) ) )CALCULATE( SUM(BD_Core[Valor]), FILTER( BD_Core, ( BD_Core[year] = 2025 && BD_Core[Versión] = "Ppto V2" ) || ( BD_Core[year] <> 2025 && BD_Core[Versión] = "VP" ) ) )

 

in order to use a filter to sum values based on two filters: the first one being the year, and the second one the version or category. So if the year is 2025 it sums the values under "V2" category. Else, under "VP". However, it just displays blank rows. Any help on this?

 

 

Thanks in advance

  • joshl525's avatar
    joshl525
    10 months ago

    Hello, I solved it using a SWITCH function:
    =SWITCH(MAX(BD_Core[Year]),2025,CALCULATE(SUM(BD_Core[Valor]),BD_Core[Versión]="Ppto V2"),(CALCULATE( SUM(BD_Core[Valor]), BD_Core[Versión] = "VP" )))