Forum Discussion
Chris_23
Helper II
Helper IIFilter Table by a measure does not work
Hello guys, i have a little problem regarding the filter context between two tables by measure. In Table (1) I have two columns. One with calculated margins and one with achieved margins. Are...
Hi Chris_23
It is possible to build a measure by unrelated table. If and isfiltered function is a good way to try. And you need to filter your table by values in unrelated table in measure to get your result. All values need to filter one by one in filter function in your code. Or your measure will get a wrong result.
Can you share a sample like what you are dealing with to me by your Onedrive for Business? This may make it easier for me to understand your requirement.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Measure =
IF( ISBLANK(max(Other column Name))
, BLANK() ,IF([Measure]))