DAX function to count all other DAX functions

[cottrera]

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

[cottrera]

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

[OwenAuger · Accepted solution]

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