且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Power Bi 中多场景的查找值

更新时间: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.