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!

Tahreem24's avatar
Tahreem24
Super User
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!