Forum Discussion
Remove values from one column in matrix scope
Hello,
Is there some way that not show one column values in matrix last row? I have matrix that shows how much work plan to do and how it really done, the last row of the matrix show the worker. However, the employee who will perform the work is not planned, but assigned only when the work is done. Planned work and completed work are taken from two different files.
I would need the planned column to ignore the employee in the row and not show any value next to it, is this possible?
Thank you
Hi User38690 ,
Please try this way.
Use these DAXs to create measure:_Plan = VAR _sum = SUM('Table'[Plan]) RETURN IF( ISFILTERED('Table'[Worker]), BLANK(), _sum )Put these measures into the matrix, and the final output is as below:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi User38690 ,
Please just put the measure "_Plan" and the column [Done] into the matrix. The output is as below:It will automatically show only the workers that have data in the Done.
If the problem still exists, it's not the measure, it's on your data model. This would require you to provide the pbix file for me to know exactly what the problem is. Thank you!
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi User38690 ,
Please try this way.
Use these DAXs to create measure:_Plan = VAR _sum = SUM('Table'[Plan]) RETURN IF( ISFILTERED('Table'[Worker]), BLANK(), _sum )Put these measures into the matrix, and the final output is as below:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Now it no longer shows the values next to the plan, but after expanding the month it still shows all employees. I would like to make it so that when expanded it shows only the one who did the work, according to the done column, if the work is done.
Hi User38690 ,
Please just put the measure "_Plan" and the column [Done] into the matrix. The output is as below:It will automatically show only the workers that have data in the Done.
If the problem still exists, it's not the measure, it's on your data model. This would require you to provide the pbix file for me to know exactly what the problem is. Thank you!
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
