更新时间:2023-02-02 23:41:52
尚不完全清楚您要做什么,但我认为这种度量模式可能会对您有所帮助:
It's not entirely clear what you're trying to do but I think this measure pattern may help you:
IF (
DISTINCTCOUNT ( DATA[SUPPLIER] ) > 1,
"MIXED",
SELECTEDVALUE ( DATA[SUPPLIER], "NA" )
)
对于多个值,您会得到 MIXED.对于一个值,您将获得该单个值.如果没有值,您会得到 NA.
For more than one value, you get MIXED. For one value, you get that single value. For no values, you get NA.