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 

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