Forum Discussion

elcojo2's avatar
elcojo2
Frequent Visitor
6 years ago

Filter Matrix based on 2 columns values

Hello,   I have not been able to somehow using calculated column or measure to filter this matrix to show items that meet these criteria line income amout paid > 0 and line income open amount = 0 ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Are these not working

calculate(sum(table[line Amount]),table[line income amout paid] > 0 , table[line income open amount] = 0)
calculate(sum(table[line Amount]),filter(table,table[line income amout paid] > 0 && table[line income open amount] = 0))

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

  • elcojo2's avatar
    elcojo2
    Frequent Visitor
    6 years ago

    Thanks for the reply the problem is that line income open amount and line income paid amount are already a SUM, they have a sigma symbol next to it (autosum) is this the reason I can not use this formula?

    • elcojo2's avatar
      elcojo2
      Frequent Visitor
      6 years ago

      Sorry did not see the second reply. I have 2 fields for each of this one is a measure that I created and the other one is from the db I am using with a autosum symbol like I said before.

      • v-alq-msft's avatar
        v-alq-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi, elcojo2 

         

        I want to know more about your visual hierarchical structure. It may help. Thanks

         

        Best Regards

        Allan