Forum Discussion

alvin199's avatar
alvin199
Helper III
4 years ago
Solved

Question on Relate and RelatedTable function

Hi,   I would like to know why I do not need to use RELATE OR RELATEDTABLE function on 'Sales by Store'[Total Revenue]  or 'Sales by Store', respectively, but use either one only as I am using Stor...
  • v-yingjl's avatar
    v-yingjl
    4 years ago

    Hi alvin199 ,

    In this case, you can try to use Hasonefilter instead of Hasonevalue for the column in your picture:

    Like this:

    Measure = HASONEFILTER('Table'[City])

     

    You can refer the difference between Hasonevalue and Hasonefilter:

    HASONEFILTER vs. HASONEVALUE vs. ISFILTERED 

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

alvin199's avatar
alvin199
Helper III
4 years ago

I am referring to the column Selected Product Category (Concatenatex, Ass, Improved). I would like to empty all the store_id rows across the Selected Product Category column. 

I am thinking that I need to add an expression on the IF(HasOneValue). 

v-yingjl's avatar
v-yingjl
Community Support
4 years ago

Hi alvin199 ,

In this case, you can try to use Hasonefilter instead of Hasonevalue for the column in your picture:

Like this:

Measure = HASONEFILTER('Table'[City])

 

You can refer the difference between Hasonevalue and Hasonefilter:

HASONEFILTER vs. HASONEVALUE vs. ISFILTERED 

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.