Forum Discussion

megane123's avatar
megane123
Frequent Visitor
5 years ago

COUNTDISTINCT vs COUNT for coverage calculations

Hi All,   I am struggling to work out what I think should be some fairly straightforward DAX and can't find anything in the forum. Apologies if I have missed another post.   I have a client and p...
COUNT
Countdistinct
megane123's avatar
megane123
Frequent Visitor
5 years ago

Good morning Daxer,

 

Thanks for this! I noticed you replied to my colleague's post with the same query - I had a few questions on your response, hoping you can help:

 

- You have declared AllClientCount but I don't see it used anywhere else in the measure, is this intentional?

- The variable VisibleClientCount isn't declared so will error when trying to run this.

- When you say 'put the body in', where do you mean I should include this in the measure?

 

Thanks v much in advance for your help!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Of course there's a mistake in the code but it's obvious: change the name of the variable that does not exist to the one that does. The above formula is one way to solve the problem. Another one is in the other post you mention.

 

"Put the body in..." means that the whole body of the measure should be wrapped in "IF(..."