Forum Discussion
How do I exclude rows from another table in my measure?
Hi all, Trying to create a measure and I'm not clear how to add an exclusion. I've had to run 3 different excel / BEX reports due to volume constraints and linked them in PBI. I want to sum...
amitchandak
Super User
Super Useraredmond127 , if table are related
calculate(Sum(Table[column X, Filter( Table2, Table2[column Y] <>0) )
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.