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

     

4 Replies

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

  • joshl525's avatar
    joshl525
    Frequent Visitor
    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" )))

     

  • joshl525's avatar
    joshl525
    Frequent Visitor
    10 months ago

    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.

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