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 guys and sorry in advance to bother you for this little stuff,
i have 1 single table with a measure, let's say the "price".
i calculate the average price value.
And i want to filter that table to only keep the lines where my price is above the average value.
A restaurant in Paris for the fastest helper.
(but i don't pay the flight ticket 🙂
Thanks !
Solved! Go to Solution.
it works with storing the average in a calc column and then do a FILTER(Table;price<avg_calcol)
if you have a solution without calc col, i take it.
it works with storing the average in a calc column and then do a FILTER(Table;price<avg_calcol)
if you have a solution without calc col, i take it.
oh i didn't try calculated columns to place the average in. I was hoping to do it without calc col. -:)
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |