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.
Measure to get the maximum amount for each BN and then average the maximum amount.
Below is the sample data for reference.
BN | AMOUNT |
1 | 1000 |
1 | 2000 |
1 | 3000 |
2 | 1000 |
3 | 2000 |
4 | 3000 |
2 | 3000 |
3 | 4000 |
4 | 4000 |
1 | 500 |
3 | 3500 |
5 | 4500 |
Appreciate your help.
Solved! Go to Solution.
I think you are looking for this:
Average of Max values as per BN = AVERAGEX(SUMMARIZE(BNTable,BNTable[BN],"MaxBN",MAX(BNTable[AMOUNT])),[MaxBN])
It gives an outcome of 3700 with the given data.
I think you are looking for this:
Average of Max values as per BN = AVERAGEX(SUMMARIZE(BNTable,BNTable[BN],"MaxBN",MAX(BNTable[AMOUNT])),[MaxBN])
It gives an outcome of 3700 with the given data.
Thanks.
this is the result i was looking for.
Now, what if i would like to get with code "BS" only.
Below sample refer.
BN | AMOUNT | Code |
1 | 1000 | BS |
1 | 2000 | BS |
1 | 3000 | H |
2 | 1000 | BS |
3 | 2000 | BS |
4 | 3000 | BS |
2 | 3000 | H |
3 | 4000 | BS |
4 | 4000 | BS |
1 | 500 | BS |
3 | 3500 | H |
5 | 4500 | BS |
Hi !
Thanks. But this is the result i expect.
1 | 3000 |
2 | 3000 |
3 | 4000 |
4 | 4000 |
5 | 4500 |
Average | 3700 |
You can visualise it like this:
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |