Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I am trying to find out the maximum value of the column highlighted in Red
The highlighted Red column is A calculated Measure and the columns in Blue is filtered.
I used MAXX& ALL EXCEPT. However it is giving maximum value of an unfiltered table. Plz help
Solved! Go to Solution.
Hi, @baronraghu
Try to replace ALL EXCEPT with FILTER+ALL+MAX in your measures.
like:
a =
CALCULATE ( SUM ( [value] ), ALLEXCEPT ( table, 'table'[name], 'table'[age] ) )
b =
CALCULATE (SUM ( [value] ),
FILTER (ALL ( table ),'table'[name] = MAX ( 'table'[name] )&& 'table'[age] = MAX ('table'[age] ))
)
If it doesn't work, could you please consdier sharing more details about it and posting expected result so it is clear on what needs to be implemented? And It would be great if there is a sample file without any sesentive information here. It makes it easier to give you a solution.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @baronraghu
Try to replace ALL EXCEPT with FILTER+ALL+MAX in your measures.
like:
a =
CALCULATE ( SUM ( [value] ), ALLEXCEPT ( table, 'table'[name], 'table'[age] ) )
b =
CALCULATE (SUM ( [value] ),
FILTER (ALL ( table ),'table'[name] = MAX ( 'table'[name] )&& 'table'[age] = MAX ('table'[age] ))
)
If it doesn't work, could you please consdier sharing more details about it and posting expected result so it is clear on what needs to be implemented? And It would be great if there is a sample file without any sesentive information here. It makes it easier to give you a solution.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
its not working , Please note there are two columns highlighted in blue.
Measure = MAXX ( ALLSELECTED ( 'Table'[Blue Col] ), [Red Col] )
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |