Forum Discussion
Disabling text field aggregation in matrix
Hey Everyone, I have a dashboard using a matrix visualization to summarize some data. Some of the columns are text. The text columns are aggregated (first, last, count or count distinct) and I can't...
Hi Anonymous ,
HASONEVALUE funtion might be helpful to solve your issue.
Here's a simple sample. The return value corresponding to the ID is 0, as you said, you can put blank(), the return value corresponding to the date is 1, you can put the original measurement.
Measure = IF(HASONEVALUE('Table'[Date]),1,0)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.