The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
How does the measure [NTA_Ch] look like?
Hi Jihwan,
It is a calculation based on a series of other calculations:
Please share the sample pbix file's link.
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.
Many thanks Jihwan, Looks like this will do the trick.