Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Doubt in Matrix

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!

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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])))

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.