Forum Discussion
Remove values from one column in matrix scope
- Anonymous2 years ago
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. - Anonymous2 years ago
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 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.