Forum Discussion
Helper IFilter rows of a table based on another visual
Hi taralouise123 ,
You can try formula like below to create measure:
M1 = IF(MAX(Projects[Percentage Completion]) = 1,1,0)M2 = IF(MAX(Projects[Percentage Completion]) = 1,0,1)result = IF(ISFILTERED(Projects[Project Name]),[M1],[M2])put result to table filter, if not select column in visual, the table visual shows not 100% rows:
after select column about 100%, the result show below:
Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi taralouise123 ,
You can try formula like below to create measure:
M1 = IF(MAX(Projects[Percentage Completion]) = 1,1,0)M2 = IF(MAX(Projects[Percentage Completion]) = 1,0,1)result = IF(ISFILTERED(Projects[Project Name]),[M1],[M2])
put result to table filter, if not select column in visual, the table visual shows not 100% rows:
after select column about 100%, the result show below:
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
taralouise123Thank you! This has helped. It's not filtered my table completely but it has removed the 100% completed tasks and then adding percentages in my project category table has helped with being able to drill through onto the 100% completed tasks anyway, so it's solved my issue, thanks.