Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello,
I've got this PBIX
and this measure
Measure = (CALCULATE(SUM('Table'[Value]);'Table'[Type1]<>"REVENUE")*-1)/CALCULATE(SUM('Table'[Value]);'Table'[Type1]="REVENUE")
that I'd like to correct in order to divide costs (in every hierarchy level) with whatever value I obtain under total REVENUE from my filter visual selection.
By design Type 3 column could have a value that has a value as cost, revenue, both or none.
I tried changing calculate argument with filter function but without success. Is it possible?
Thanks in advance
Solved! Go to Solution.
Hi @AGo ,
Your requirement is not very clear. However, you can try this measure.
Hi @AGo ,
Your requirement is not very clear. However, you can try this measure.
Your solution worked like a charm for costs! Thanks. The only strange fact is that the measure gives a result of 76% under REVENUE that should be totalrevenue/totalrevenue=x/x=1=100% or better hidden
Hi @AGo ,
Thanks that you liked the solution.
Please use this formula for __nrt1. This will remove the 77% from Revenue.
Hi @AGo ,
I didn't get exaclty what you want to do. But perhaps it should work: