Forum Discussion

joshl525's avatar
joshl525
Frequent Visitor
1 year 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
    1 year 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
Icon for Community Support rankCommunity Support
1 year 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.