Count vs Sum

[HenryJS]

Hi all,

I have written the below DAX code to return a count of all rows where HasAdvert = Yes and JobStatus = Open. This should return a value of 16 but it is showing as 18? I have it to display as a Count?

As in picture 3 it should return a value of 16.

1. DAX code 

2. Table in PowerBI 

3. Base data

[v-easonf-msft]

Hi , @HenryJS 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or your reply as Answered to close this thread?

Best Regards,
Community Support Team _ Eason

[Tahreem24 · Accepted solution]

@HenryJS ,

As per your description your measure name is "Advertised Open Job 2" but when you drag it in table so title of that column become "Count of Advertised Open Job 2 " means Count aggregation is selected on top of your measure created.

So please make it "Don't Summerize" as per screen shot shared by @v-easonf-msft .

Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!

[v-easonf-msft]

Hi , @HenryJS 

I can’t reproduce your problem. It works well in my PowerBI report.

I am not sure which one  you are using ,calculated column or measure?

If you are using calculated column, please pay attention to your type of summarization here .

And I suggest you’d better to use measure here.

Here is a sample I made :

URL: https://wicren-my.sharepoint.com/:u:/g/personal/michael_wicren_onmicrosoft_com/EZSMDSQUiRpAsjQe4GU3a...

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.