Filter Matrix based on 2 columns values

[elcojo2]

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

Any help would be appreciated.

[v-alq-msft]

Hi, @elcojo2 

Based on your screenshot, I have something to confirm. I wonder 'line income amount' and 'line income open amount' are columns or measures. If possible, please show me your slicers, filters. Do mask sensitive data before uploading. I am glad to solve the problem for you. Thanks

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

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-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[elcojo2]

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]

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]

Hi, @elcojo2 

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

Best Regards

Allan

[elcojo2]

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