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

Anonymous

It still doesn't work because now it show almost in all cells 100% and some are empty because they have a status <> the ones in the formula.

The meaning was to calculate the total sum of all 'Orders' devided by all the customers I made a bid. So if i have 5 orders but made 100 bids then i have a 5% order rate

 

In this formula im missing the part where it counts all the rows with the status 'Order'

RvdHeijden's avatar
RvdHeijden
Post Prodigy
9 years ago

Anonymous

Correction because im not sure if im missing that column. it's just that i have only 2 values now....it's either 100% or BLANK