Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
84 | |
83 | |
67 | |
49 |
User | Count |
---|---|
131 | |
111 | |
97 | |
71 | |
67 |