Forum Discussion
Anonymous
4 years agoNot applicable
Hide card in conditional situation
Hi I am creating a dashboard and I have a calendar view and three cards (A. total stops; B: Total Routes; C: Stops per route, which is dividing total stops by total routes) I am feeding the calen...
- Anonymous4 years ago
Hi Anonymous ,
You could simply use IF() and ISFILTER() function to create measure to display different values in different situations.
For example:
measure = IF(ISFILTERED('calendar'[date]),selectedvalue('calendar'[date]),max('calendar'[date].month))Best Regards,
Jay
amitchandak
Super User
4 years agoAnonymous , use isfiltered and check is month or date filtered and based on that change measure
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/