powerbi - 使用未透视列的切片器的 TOTAL 度量百分比

Question

我正在尝试计算将与切片器一起出现的 unpivot 列的总数百分比。我对 power bi 还很陌生，所以这可能很容易。但是，我在尝试使其工作时遇到了麻烦。任何帮助，将不胜感激。

我有一个样品表，

EID Gender  Company Bilingual
456 Male    A   Can Speak two languages
123 Female  A   Can speak one language
097 Male    B   Can Speak two languages
678 Female  B   Can Speak two languages
345 Male    B   Can speak one language
234 Male    A   Can speak one language
098 Female  A   Can Speak two languages
786 Female  A   Can speak one language
546 Female  B   Can Speak two languages
874 Female  B   Can Speak two languages
012 Male    A   Can Speak two languages
023 Male    A   Can speak one language
056 Male    B   Can speak one language
604 Female  B   Can Speak two languages

我对性别和双语列进行了反透视，

EID Company Unpivot
456 A   Male
456 A   Can Speak two languages
123 A   Female
123 A   Can speak one language
097 B   Male
097 B   Can Speak two languages
678 B   Female
678 B   Can Speak two languages
345 B   Male
345 B   Can speak one language
234 A   Male
234 A   Can speak one language
098 A   Female
098 A   Can Speak two languages
786 A   Female
786 A   Can speak one language
546 B   Female
546 B   Can Speak two languages
874 B   Female
874 B   Can Speak two languages
012 A   Male
012 A   Can Speak two languages
023 A   Male
023 A   Can speak one language
056 B   Male
056 B   Can speak one language
604 B   Female
604 B   Can Speak two languages

之后，我创建了一个看起来像这样的表，

正如你所看到的，当我只为一家公司选择它时，我的“%”度量是不正确的。但是，当我选择这两个公司时，它显示正确。

我的度量代码如下：

% = 
CALCULATE(
    DIVIDE(
        DISTINCTCOUNT('Table'[Employee ID]),
        CALCULATE(
            DISTINCTCOUNT('Table'[Employee ID]),
            ALLSELECTED()
        )
    )
)

有没有办法创建一个可以根据过滤器动态工作的度量？请告诉我。

标签： powerbidax

Answer 1

尝试以下措施：

% = DIVIDE(COUNTA('Table'[Value]),COUNTROWS(Table))

请注意，'Table'[Value] 指的是存储性别和语言的列。