count - Power BI - 我如何计算列中值的出现次数？

Question

我对此进行了研究，但无法使其正常工作。我是 Power BI 的新手。在图像中（我审查了用户 ID），您可以看到我突出显示了订单 0625140，因为它应该总计为 3。我已经尝试过计算列

Totals = CALCULATE( COUNT('Billing KPIs'[index])
, ALLEXCEPT('Billing KPIs', 'Billing KPIs'[order_id])) 
and quick measures and custom measure .

Totals =
   SUMX(
      VALUES(Data[User]), 
      CALCULATE(COUNT(Data[Group]))
   ) Based on previous posts but nothing has worked yet.  Please advise and thank you for your time.[Image of Data table][1]

标签： countpowerbimeasure

Answer 1

总计 = CALCULATE( COUNT('Billing KPIs'[index]) , ALLEXCEPT('Billing KPIs', 'Billing KPIs'[order_id])) 我道歉了。