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,
I have a (large) table that looks something like this:
In this random example, the average weight deviations are:
Product A: +2,2 % //
Product B: +3,6 % //
Product C: -0,33 %
I need a measure to, in this case, pick put "Product B" for the largest average weight deviation.
Any suggestions?
Product | Weight | Actual weight | Deviation |
Product A | +1 % | ||
Product B | +3,2 % | ||
Product C | + 0,4 % | ||
Product A | + 5 % | ||
Product B | + 2,9 % | ||
Product C | - 0,4 % | ||
Product A | + 0,6 % | ||
Product B | + 4,7 % | ||
Product C | -1 % |
Solved! Go to Solution.
Hi @sigridr ,
Please have a try.
Create measures.
Measure = AVERAGEX(FILTER(ALL('Table'),'Table'[Product]=SELECTEDVALUE('Table'[Product])),'Table'[Weight Actual])
measure2=maxx(all(table),[measure])
Or a column.
column = AVERAGEX(FILTER(ALL('Table'),'Table'[Product]=EARLIER('Table'[Product])),'Table'[Weight Actual])
measure=maxx(all(table),table[column])
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @sigridr ,
Please have a try.
Create measures.
Measure = AVERAGEX(FILTER(ALL('Table'),'Table'[Product]=SELECTEDVALUE('Table'[Product])),'Table'[Weight Actual])
measure2=maxx(all(table),[measure])
Or a column.
column = AVERAGEX(FILTER(ALL('Table'),'Table'[Product]=EARLIER('Table'[Product])),'Table'[Weight Actual])
measure=maxx(all(table),table[column])
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I think I can do it with this formula:
I tried 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 |
---|---|
47 | |
24 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |