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

     

v-venuppu's avatar
v-venuppu
Community Support
10 months ago

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.