Forum Discussion
Remove values from one column in matrix scope
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.
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.Oh thank you, there was another measure with which I had to do the same.