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.
Hi All,
I am trying to translate a calculation I created in excel into Power Bi and am running into major issues. I was hoping that someone could take a look at the two attached files and give me some insight on what is going on. The excel file has the results that I am looking for.
https://drive.google.com/open?id=1HN8Z1COYbUMyT2rptIkHfWd6RupbvHuN
Solved! Go to Solution.
Hi @nmck86,
Please check out the demo here.
I would suggest you use the original data instead of the unpivot data. For example below, filtering out the row in the red rectangle from the unpivot table would be very hard.
Water Quality = DIVIDE ( CALCULATE ( SUM ( 'Result'[Weights] ), FILTER ( 'Result', 'Result'[likeliness to recommend] >= 9 && 'Result'[water quality] = EARLIER ( Rankings[Value] ) ) ) - CALCULATE ( SUM ( 'Result'[Weights] ), FILTER ( 'Result', 'Result'[likeliness to recommend] <= 6 && 'Result'[water quality] = EARLIER ( Rankings[Value] ) ) ), CALCULATE ( SUM ( 'Result'[Weights] ), 'Result'[water quality] = EARLIER ( Rankings[Value] ) ) )
Water Prices = DIVIDE ( CALCULATE ( SUM ( 'Result'[Weights] ), FILTER ( 'Result', 'Result'[likeliness to recommend] >= 9 && 'Result'[water price] = EARLIER ( Rankings[Value] ) ) ) - CALCULATE ( SUM ( 'Result'[Weights] ), FILTER ( 'Result', 'Result'[likeliness to recommend] <= 6 && 'Result'[water price] = EARLIER ( Rankings[Value] ) ) ), CALCULATE ( SUM ( 'Result'[Weights] ), 'Result'[water price] = EARLIER ( Rankings[Value] ) ) )
Best Regards,
Dale
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |