Forum Discussion
hasonevalue
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)
i fixed it thanks, i used my solution, it worked after i restarted the pc
4 Replies
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
i fixed it thanks, i used my solution, it worked after i restarted the pc
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
hasonevalue('fact table'[customer ID])
wrong table name
