Forum Discussion
Helper IIIQuestion on Relate and RelatedTable function
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.
Super Useralvin199
You can use the RELATEDTABLE function when you the Dimension level and need to fetch data from the FAct table, as it returns a table you need to do the calculation.
To get rid of the two-line in the matrix, get rid of the Steped Layout:
Helper IIII 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-yingjlCommunity Support
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.