hasonevalue

[chahineatallah]

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)

[v-cazheng-msft]

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

[chahineatallah · Accepted solution]

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

[v-cazheng-msft]

@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

[vapid128]

hasonevalue('fact table'[customer ID])

wrong table name