Forum Discussion
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
Any help would be appreciated.
6 Replies
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/823601Thanks 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?
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.
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.
