Forum Discussion
Add a column in M code and filter it on a condition based on a value in another table's column
Hi all, Is it possible to add a column in M code and filter that added column on a condition based on a value in a column in a related table? For example, we want to add a column displaying all Pr...
It si bad pratice to add M columns each time you need a filter.
Use a DAX measure instead ...
Total cost = SUM('Fact costs'[Cost]) + 0Then filters Total cost = 0Click here to download an example
Please click thumbs up and accept as solution
speedramps
Super User
Super UserIt si bad pratice to add M columns each time you need a filter.
Use a DAX measure instead ...
Total cost = SUM('Fact costs'[Cost]) + 0
Then filters Total cost = 0
Click here to download an example
Please click thumbs up and accept as solution