Doubt in Matrix

[Anonymous]

Hello Team,

I have a scenario where i need to show only the categories which has values otherwise the category should not be shown also the category should automatically appear if we get any value in future. Is there any solution for this?

Thanks in Advance!

[Anonymous]

Thanks for the swift response @amitchandak ,

But if we use the measure which you have shared we are getting the entire sum / count which is been spread across the date range. for instance if we have values 10,20 & 30 for Jan, Feb & Mar respectively and if we use the created measure in the matrix it is giving us 60 (sum of those values) across the entire date range ( from Jan to Dec) everywhere its 60.

[amitchandak]

@Anonymous , That should be the default behavior.

Create this measure and check this is not blank in the visual level filter

calculate([measure], filter(allselected(Table), Table[Category] = max(Table[Category])))