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'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:
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |