Forum Discussion

chahineatallah's avatar
chahineatallah
Helper III
4 years ago
Solved

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 ea...
  • chahineatallah's avatar
    chahineatallah
    4 years ago

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

v-cazheng-msft's avatar
v-cazheng-msft
Community Support
4 years ago

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's avatar
chahineatallah
Helper III
4 years ago

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

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Community Support
    4 years ago

    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