Forum Discussion
Solved
Help with calculating Min/Max values for Chart
Hi, I am very puzzled by this behaviour and want to seek community members advise. I am trying to determine Min/Max values of a chart using the DAX formula below:- MaxOppWonValue_MthName ...
An very hidden pitfall of "Sort by Column" setting. You may refer to this article,
Side effects of the Sort By Column setting in DAX - SQLBI
MinOppWonValue_MthName = MINX ( ALLSELECTED ( 'Calendar'[Mth] ), CALCULATE([OppWonValue], ALL('Calendar'[MonthNumberOfCalendarYear])) )
Wow, thanks for the quick response. I remember reading that particular article and making a mental note for future (which obviously didn't help in this instance hahaha).
End result that I was trying to achieve: