Forum Discussion

JGG's avatar
JGG
Helper I
5 years ago
Solved

One filter too many?

Hi, I got help in the Community with the following:   CostAllPerCustomer = CALCULATE(SUM('Cost'[Amount]),'Cost'[Type] IN {"All"},'Cost'[Distribution] IN {"Customer"})/CALCULATE(DISTINCTCOUNT('Custo...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    If your CustomerID column is numeric data type, remove the quotes around 123456.

    Regards,

    Pat

     

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

If your CustomerID column is numeric data type, remove the quotes around 123456.

Regards,

Pat