Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
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
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?
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
I want to know more about your visual hierarchical structure. It may help. Thanks
Best Regards
Allan
There is not really hierarchical structure, job cost table and inside measures and the autosum.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |