Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago
Solved

Count vs Sum

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 ...
Need Help
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    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's avatar
v-easonf-msft
Community Support
6 years ago

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/EZSMDSQUiRpAsjQe4GU3aA4B4lZsFfIdi1S4DoIYEyrXQA?e=5lBt3X

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.