topic Re: hasonevalue in DAX Commands and Tips

hasonevalue

chahineatallah — Tue, 19 Jul 2022 19:02:04 GMT

hi everyone

am using hasonevalue, but i dont know why its not working, in my date filter context i should have 3 customers, so my hasonevalue should give blank, but when i expand the date then each customer ,his salary should be shown as filter context now only shows one customer , isnt? or am missing on something, as i put hasonevalue(customerid)

Re: hasonevalue

vapid128 — Tue, 19 Jul 2022 22:46:30 GMT

hasonevalue('fact table'[customer ID])

wrong table name

Re: hasonevalue

v-cazheng-msft — Fri, 22 Jul 2022 02:17:37 GMT

Hi chahineatallah,

May I know if you correct your table name used in the dax formula, will you get what you want?

total salary = IF(HASONEVALUE('fact table'[customer ID]),SUM(customer[salary]),"")

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun

Re: hasonevalue

chahineatallah — Sat, 23 Jul 2022 08:15:42 GMT

i fixed it thanks, i used my solution, it worked after i restarted the pc

Re: hasonevalue

v-cazheng-msft — Mon, 25 Jul 2022 00:59:11 GMT

chahineatallah,

That's great! Thanks for your reply!

Could you please share and mark your solution by Accept it as the solution to close this post and help others find it more quickly? Thanks in advance!

Best Regards,

Community Support Team _ Caiyun