Ask Your Question
4

What is the DAX measure to display line items that contain empty values?

asked 2022-11-23 11:00:00 +0000

bukephalos gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
2

answered 2022-07-26 01:00:00 +0000

woof gravatar image

The DAX measure to display line items that contain empty values is:

= CALCULATE(COUNTBLANK(Table1[Column1]))

This will count all the blank values in "Column1" of "Table1". You can replace "Table1[Column1]" with the name of the table and column that contains the data you want to count.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2022-11-23 11:00:00 +0000

Seen: 12 times

Last updated: Jul 26 '22