Forum Discussion
cottrera
Post Prodigy
3 years agoDAX function to count all other DAX functions
Hi Community I have a report that has a visual table containing a set amount of DAX functions. Some produce results , were as others do not. I would like a final DAX function that counts all ot...
- 3 years ago
Hi cottrera
I would suggest creating a measure that assembles the existing measures in a single-column table then counts the nonblank values.
Here's how I would do it:
Nonblank Measure Count = VAR MeasureValues = { [Measure 1], [Measure 2], [Measure 3], [Measure 4], [Measure 5], [Measure 6] } RETURN COUNTROWS ( FILTER ( MeasureValues, NOT ISBLANK ( [Value] ) ) )Does this work for you?
Regards
cottrera
Post Prodigy
3 years agoHi Owen thank you for responding so quickly and appologies for my late response. Your measure works fine thank you Richard😀