Forum Discussion

RvdHeijden's avatar
RvdHeijden
Post Prodigy
9 years ago
Solved

What am i doing wrong

Hello,   Im a DAX newbie but have a background in Excell and in Excell i would have figured out this problem in minutes but in DAX it already cost me a couple of days because they way formules are ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Scoringskans =
    DIVIDE (
        CALCULATE ( COUNTROWS ( Project ); Project[StageName] = "Order" );
        CALCULATE (
            COUNTROWS ( Project );
            Project[StageName] = "Order"
                || Project[StageName] = "Lost Order"
                || Project[StageName] = "Bid Made"
                || Project[StageName] = "Prospect"
        )
    )

     

     

     

    Take note that in my example I have 1 line for "Other" which I don't include in my formula so I have 6/12 = 0,5 which is correct.

Bokazoit's avatar
Bokazoit
Continued Contributor
9 years ago

CALCULATE is a multi-parameter function. You need to say

 

=CALCULATE(DISTINCT(Project[Stagename]);Project[Stagename] = "ORDER")/(CALCULATE(COUNT(Project[Stagename]);Project[Stagename] ="xxx")+CALCULATE(COUNT(Project[Stagename]);Project[Stagename] ="xxx")+CALCULATE(COUNT(Project[Stagename]);Project[Stagename] ="xxx")+CALCULATE(COUNT(Project[Stagename]);Project[Stagename] ="xxx"))

  • RvdHeijden's avatar
    RvdHeijden
    Post Prodigy
    9 years ago

    Bokazoit

    Apparently your formule doesn't work either however there is a bigger chance that i did something wrong.

    Can you tell me what it is ?

     

    ScoringsKans2 = CALCULATE(DISTINCT(Project[Stagename]);Project[Stagename] = "ORDER")/(CALCULATE(COUNT(Project[Stagename]);Project[Stagename] ="Lost Order")+CALCULATE(COUNT(Project[Stagename]);Project[Stagename] ="Order")+CALCULATE(COUNT(Project[Stagename]);Project[Stagename] ="Prospect")+CALCULATE(COUNT(Project[Stagename]);Project[Stagename] ="Bid Made"))

     

    The error reads: "The function COUNT takes an argument that evaluates to numbers or dates and cannot work with values of type String."

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      COUNT doesn't count string types of cells. Instead use COUNTA

    • Bokazoit's avatar
      Bokazoit
      Continued Contributor
      9 years ago

      It says that the Count function will not work with string type. I used the function I put in here on my own data with a ProductId which is a number. Try to convert the stagename to an id, and I am pretty sure it will work :)