Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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
Hi Owen thank you for responding so quickly and appologies for my late response. Your measure works fine thank you Richard😀
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
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |