topic Re: DAX function to count all other DAX functions in DAX Commands and Tips

DAX function to count all other DAX functions

cottrera — Wed, 26 Jul 2023 10:51:29 GMT

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 other the other measures and provides a total count of how many produce a result.

Below is an example of how I see this working

Reference #	Measure 1	Measure 2	Measure 3	Measure 4	Measure 5	Measure 6	How many of the other measures output a result
1234	5			1			2
5432	2	3	2	4	5	1	6
5456	5	6	un checked		3		4
6787	2	2	4				3

Thank you

Richard

Re: DAX function to count all other DAX functions

OwenAuger — Wed, 26 Jul 2023 20:37:09 GMT

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

Re: DAX function to count all other DAX functions

cottrera — Tue, 01 Aug 2023 09:35:54 GMT

Hi Owen thank you for responding so quickly and appologies for my late response. Your measure works fine thank you Richard😀