Using two filters with a conditional

[joshl525]

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

[v-venuppu]

Hi @joshl525 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Irwan for the prompt response.

Great to hear that it's got solved from your end.I would suggest accepting your approach as the solution so that it will be really helpful for others in the community who might be facing similar issues and can address them quickly.

[joshl525 · Accepted solution]

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" )))

[joshl525]

Hello, Irwan, 

Thanks for your answer. The thing is that I'm not using visuals, just DAX, and queries in Excel, not in Power BI.

[Irwan]

hello @joshl525 

i dont know how your visual will be, but i think you can use filter or slicer to calculate sum when 2025 or/and under certain value to avoid more complex DAX.

Hope this will help.

Thank you.