Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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. -:)
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |