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.

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."

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 :)