Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Community -
In the following table visual, the totals for the following measures are intentionally blank.
- Accounts
- Retained
- Retained %
These 3 measures (renamed) show BLANK for the Total row by using ISFILTERED on the Year.
So far so good.
The problem comes when I need to only show rows in the table visual where CY Premium > 0.
For example, 2024 is currently showing in the table visual, but should not appear until CY Premium > 0.
To achieve this, the following visual filter is created.
GOOD - This filter correctly hides the 2024 row because CY Premium is not greater than 0 in that year.
BAD - However, doing so breaks the intentional BLANKING of the 3 measures mentioned at the beginning of this post.
How do I get both requirements to work at the same time?
I thought about doing the ISFILTERED on a different column in the table.
The problem is that every column in the table visual (except Year) is just another measure which cannot be used in the ISFILTERED clause to BLANK a measure in the totals row.
Any guidance would be greatly appreciated.
Regards,
Nathan
Solved! Go to Solution.
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |