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 All:
I have a table grouped by Ids and for each Id there are several rows. Unfortunately, both the max and min values of a column I wish to display are spurious and I want to filter them out of the aggregates.
i.e. something like the following psuedo code:
Average all values in col X that are not Min[X] nor Max[X] Group By ID
any thoughts?
thx
Solved! Go to Solution.
Hi @MidiGlitch,
Add this measure to your data:
Average_Without_Max_MIN = VAR Maximum = MAX ( Table2[Values] ) VAR Minimum = MIN ( Table2[Values] ) RETURN CALCULATE ( AVERAGE ( Table2[Values] ), Table2[Values] <> Maximum && Table2[Values] <> Minimum )
As you can see below it ignores the max and minimum in each group
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MidiGlitch,
Add this measure to your data:
Average_Without_Max_MIN = VAR Maximum = MAX ( Table2[Values] ) VAR Minimum = MIN ( Table2[Values] ) RETURN CALCULATE ( AVERAGE ( Table2[Values] ), Table2[Values] <> Maximum && Table2[Values] <> Minimum )
As you can see below it ignores the max and minimum in each group
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsExcellent, except...
After allowing DAX expressions in Options, I am just getting back zeros
Hi @MidiGlitch,
How is your visuals set-up? Did you do a Measure?
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |