Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am calculating the budget in relation to the dates. Some dates are blank but have values, which I don't want to show on my visual, it does not work well when I use the filter and it still appears in my cumulative values. Thus, I want to exclude them from my measure:
"Budgeted values" field contains the values and "Plan to award" field contains the dates.
How can I exclude the values assigned to to blank dates from my measure?
Please see below:
Thanks,
Rytis
Solved! Go to Solution.
@Rytis , use budget measure as visual level filter , that will remove dates that do not have budget
if you want to show you add +0 or use this option
@Rytis , use budget measure as visual level filter , that will remove dates that do not have budget
if you want to show you add +0 or use this option
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |