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'

Anonymous's avatar
Anonymous
Not applicable
9 years ago

For that you need 2 CALCULATIONS functions in your formula AND not count distinct...

 

 

ScoringskansORDERS.vs.BIDSMADE RATIO = DIVIDE(CALCULATE(COUNTROWS(Project[StageName]);Project[StageName] = "Orders"));CALCULATE(COUNTROWS(Project));Project[StageName]= Project[StageName]="Bid Made")

  • RvdHeijden's avatar
    RvdHeijden
    Post Prodigy
    9 years ago

    Anonymous

    I think we are almost so thanks for your time and help but there im missing a couple of values in the formula.

     

    ScoringsKans2 = DIVIDE(CALCULATE(COUNTROWS(Project[Stagename]);Project[Stagename] = "order";CALCULATE(COUNTROWS(Project));Project[StageName]"Lost Order"||Project[StageName]="Bid made"||Project[StageName]="Order"||Project[StageName]="Prospect")

     

    Simply put i want to calculate #Orders / (SUM(#Lost Orders+#Bid made+#Order+#Prospect)

    • Anonymous's avatar
      Anonymous
      Not applicable
      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

        Thank you, this works and it reads a 40,58 % change on an order