Forum Discussion
Remove Blanks on Measure
I have a selection of measures created to show total number of times i did a particular activity, which is working fine but when I use the filter to select that activity across the whole report, the Card visuals for the other activities show as Blank. I would like to show as NA (Not Applicable).
Activity Type Date
| Breathwork | 22/01/2023 0:00 |
| Walking | 22/01/2023 0:00 |
| Yoga | 21/01/2023 0:00 |
| Walking | 21/01/2023 0:00 |
| Walking | 20/01/2023 0:00 |
| Yoga | 19/01/2023 0:00 |
| Strength Training | 19/01/2023 0:00 |
| Walking | 19/01/2023 0:00 |
I also have a date table
Activity Type Date TimeHours & Minutes MinutesMinjutes as ValuesTime SpentAvg HRMax HRElapsed Time
| Breathwork | 22/01/2023 0:00 | 0:05:32 | 00:05 | 05 | 5 | Over 40 | 144 | 151 | 05:32.1 |
| Walking | 22/01/2023 0:00 | 1:00:18 | 01:00 | 60 | 60 | Over 40 | 111 | 127 | 1:00:18 |
| Yoga | 21/01/2023 0:00 | 0:25:42 | 00:25 | 25 | 61 | Over 40 | 82 | 111 | 0:25:42 |
| Walking | 21/01/2023 0:00 | 1:00:12 | 01:00 | 60 | 62 | Over 40 | 105 | 117 | 1:00:12 |
| Walking | 20/01/2023 0:00 | 0:51:05 | 00:51 | 51 | 63 | Over 40 | 116 | 131 | 0:51:05 |
| Yoga | 19/01/2023 0:00 | 0:22:50 | 00:22 | 22 | 64 | Over 40 | 88 | 114 | 0:22:50 |
| Strength Training | 19/01/2023 0:00 | 0:13:41 | 00:13 | 13 | 65 | Over 40 | 109 | 135 | 0:13:41 |
| Walking | 19/01/2023 0:00 | 0:20:31 | 00:20 | 20 | 66 | Over 40 | 106 | 121 | 0:20:31 |
| Walking | 18/01/2023 0:00 | 0:52:04 | 00:52 | 52 | 67 | Over 40 | 115 | 136 | 0:52:07 |
Perfect - thanks heaps!
5 Replies
Hi,
There should not be a need to write a seperate measure for each Activity type. This simple measure should work
Measure = countrows(Activities)
The filter of Activity type will get picked up from the slicer selection itself.
Avoid showing a N/A because that is a text entry and the measure will return a number so you will have multiple data types.
Thanks Ashish_Mathur great suggestion! I have changed the Measure and used the filter- much easier 🙂 I also added +0 as suggested in the other response to ensure I can display a zero when page filter is used.
You are welcome.
The below video should help you achieve the results you are looking for.
Show 0 or Not Applicable Instead of Blank
Regards
Mohammed Ismail
Perfect - thanks heaps!
