topic how dax can calculate field parameter corresponding maximum value dynamically in DAX Commands and Tips

how dax can calculate field parameter corresponding maximum value dynamically

Anonymous — Thu, 08 Sep 2022 17:11:52 GMT

When switching the year, quarter and month of the field parameters, I hope to get the maximum value of different time periods as the maximum value of the y-axis, but I can't get the maximum value dynamically. The maximum value corresponding to different time intervals can be calculated, but it can't be obtained dynamically. How can I get the maximum value of different time periods dynamically with DAX? That is, when I switch the year, quarter and month of the field parameter, the measurement can automatically obtain the maximum value of the corresponding interval

Re: how dax can calculate field parameter corresponding maximum value dynamically

Jihwan_Kim — Fri, 09 Sep 2022 05:33:54 GMT

Hi,

I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached file.

As you can see in the measure, I tried to create additional column [Period CC] in the field parameter table, and then I used this column in the measure.

Max qty by period select measure: = SWITCH ( SELECTEDVALUE ( Period[Period CC] ), "M-Y", MAXX ( VALUES ( 'Calendar'[M-Y] ), [Quantity total measure:] ), "Q-Y", MAXX ( VALUES ( 'Calendar'[Q-Y] ), [Quantity total measure:] ), "Year", MAXX ( VALUES ( 'Calendar'[Year] ), [Quantity total measure:] ) )

Re: how dax can calculate field parameter corresponding maximum value dynamically

Anonymous — Mon, 12 Sep 2022 15:41:33 GMT

hi,kim,

thank you very much. Your suggestion is very helpful. According to your example, it is normal to create a column in the field parameter table for measurement judgment. If the original column in the field parameter table is used for judgment, the measurement will report an error. The original column that has been used before can not be found. Thank you again for your help