Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi all,
Hopefully a simple solution: I have a calculated table which brings in a measure (NTA_Ch) which is working fine, my issue is adding a FILTER to exclude values where the measure does not apply. It currently includes a first row (-100%) that shouldn't be calculated and also trailing values (pictured).
I had expected to be able to include "FILTER (Table, underlying number <> BLANK())" however this seems to change the context of the measure and break the calculation? Any thoughts on a way around this?
Solved! Go to Solution.
Sorry, but I cannot fully understand the related tables and measures.
Please try the below whether it suits your request. I think you can add more conditions to the below if you need more to filter.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
How does the measure [NTA_Ch] look like?
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi Jihwan,
It is a calculation based on a series of other calculations:
Please share the sample pbix file's link.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Sorry, but I cannot fully understand the related tables and measures.
Please try the below whether it suits your request. I think you can add more conditions to the below if you need more to filter.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Many thanks Jihwan, Looks like this will do the trick.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
96 | |
90 | |
81 | |
69 |
User | Count |
---|---|
157 | |
125 | |
116 | |
111 | |
95 |