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])) )
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]))
)