Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I want to calculate the Reveune per Hls (Hectre litres) and I am having problems defining this using measures. The data is in the following format. Thanks for your help
Solved! Go to Solution.
Hi,
Try this measure
=CALCULATE(SUM(Data[Value]),Data[Attribute]="TotalNetRevenue")/CALCULATE(SUM(Data[Value]),Data[Attribute]="TotalHits")
Hope this helps.
Hi,
Which 2 columns do you want to divide?
Hello Ashish,
I want to divide "TotalNetRevenue" by "TotalHls". They are different items under the "attribute" column, with the actual amounts under the "value" column.
Thanks for your help
Hi,
Try this measure
=CALCULATE(SUM(Data[Value]),Data[Attribute]="TotalNetRevenue")/CALCULATE(SUM(Data[Value]),Data[Attribute]="TotalHits")
Hope this helps.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |