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

     

Irwan's avatar
Irwan
Super User
10 months ago

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.