powerbi - Power BI 计算连续出现的次数

Question

这是我的数据库：

Name| 1st    | 2nd  | 3rd  | 4th  | 5th

Ann |   five | five | four | five | one

Tom |   four | one  | four | five | four 

我想要做的是创建包含一行中出现次数的列，所以在这种情况下我想要实现的是：

Name|   1st  | 2nd  | 3rd  | 4th  | 5th  | Five| Four | One    

Ann |   five | five | four | five | one  |  3  |  1   | 1

Tom |   four | one  | four | five | four |  1  |  3   | 1

标签： powerbidax

Answer 1

理想情况下，您希望对数据进行反透视，使其看起来像这样：

Name | Number | Value
-----|--------|------
Ann  | 1st    | five
Ann  | 2nd    | five
Ann  | 3rd    | four
Ann  | 4th    | five
Ann  | 5th    | one
Tom  | 1st    | four
Tom  | 2nd    | one
Tom  | 3rd    | four
Tom  | 4th    | five
Tom  | 5th    | four

Name然后，您可以通过放置行、Value列和Number值字段中的计数来轻松创建这样的矩阵视觉效果。

---

我不推荐它，但如果您需要将其保留在当前布局中，那么您的计算列可以这样写：

Five = (TableName[1st] = "five") + (TableName[2nd] = "five") + (TableName[3rd] = "five") +
       (TableName[4th] = "five") + (TableName[5th] = "five")

Four和One列公式将是类似的。