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
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
    Community Support
    6 years ago

    Hi, elcojo2 

     

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

     

    Best Regards

    Allan

    • elcojo2's avatar
      elcojo2
      Frequent Visitor
      6 years ago

      There is not really hierarchical structure, job cost table and inside measures and the autosum.