topic Re: Limit dax with value from visual card in DAX Commands and Tips

Limit dax with value from visual card

Kemalnugraha — Sun, 22 May 2022 10:57:35 GMT

Hi,

can i limit "calendar" table maximum date with value from visual card automatically?

the visual card and year week slicer is from another table named "calendar master"

or any other method will work?

Re: Limit dax with value from visual card

daXtreme — Sun, 22 May 2022 11:37:49 GMT

No, you can't. Model tables are always static. They are refreshed only at data refresh, not when a measure changes or anything on a visual.

Re: Limit dax with value from visual card

Jihwan_Kim — Sun, 22 May 2022 12:15:06 GMT

Hi,

Could you please describe why the limitation of maxdate of a calendar table that is dynamically changing is needed? Some problems might be solved by creating a virtual calendar table that the maxdate is limited by the selection from the master-calendar-table.

If you need a dynamically-changing-calendar-table by the user's selection from a slicer, please try to consider to solve a problem by creating a virtual calendar table.

Re: Limit dax with value from visual card

Kemalnugraha — Sun, 22 May 2022 12:37:46 GMT

i want to see the data shown by any card visual which is YTD calcualtion from other many table (about 50 table with many measure) with relation to calendar table per yearweek (YYYYMM), if i using regular slicer the data wont show because its YTD calculation, i need to limit this master "calendar" based on slicer filter or is there any method?

Re: Limit dax with value from visual card

Jihwan_Kim — Sun, 22 May 2022 12:49:38 GMT

Hi,

Thank you for your feedback.

I am not sure if I understood your question correctly, but I think creating one more disconnected-calendar-master-slicer table might solve the issue.

In order to fix existing YTD measures, the date that is selected by a slicer (disconnected slicer) may be added into the measures to limit the max date.