Forum Discussion
Solved
Hide Data at a Certain Matrix Table Level
Hello, I have a table with 1 lvl of drilldown, eg: Customer Value Sale Type A 100 xxxx --> order 1...
Probably someting like the following would work:
measure = if ( countrows ( distinct ( [salestype] ) ) > 1 , "Mix" , min ( [salestype] ) )
I'm just lazy in the comment section. Replace [Salestype] by a 'Table'[Salestype].
But the return value of a measure should always be a single value. When you apply the min expression, a string value can be returned.
Thank you! I've been working using data rather than measures too often - will try and change that 🙂