Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need help - DIVIDE with if statement in Denominator

Hi all,

Im looking for a solution to my problem. I want to do some divide with two statements in denominator like:

DIVIDE
 (COUNTROWS('Invoices),
   IF('Invoices'[Team] = "A",9,10)

Is it possiable to crate that kind of measure? I know that it isnt possiable to add reference to the column in denominator if statement....
 
Thanks in advance!



divide
if
Issue
  • selimovd's avatar
    selimovd
    4 years ago

    Hey Anonymous ,

     

    do you use it as a calculated column or as a measure?

    As you wrote it the first post it looked like a calulcated column. Then my formula should work. If you use it as a measure, you have to add an aggregation. Then the following should work:

    MyMeasure =
DIVIDE(
    COUNTROWS( 'Invoices' ),
    IF(
        MAX( 'Invoices'[Team] ) = "A",
        9,
        10
    )
)

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

6 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    4 years ago

    Hey Anonymous ,

     

    yes, that's absolutely possible.

    The following approach should work:

    MyMeasure =
DIVIDE(
    COUNTROWS( 'Invoices' ),
    IF(
        'Invoices'[Team] = "A",
        9,
        10
    )
)

     

    You could also put it in a variable if you want to, but here that is not necessary:

    MyMeasure =
VAR vIfValue =
    IF(
        'Invoices'[Team] = "A",
        9,
        10
    )
RETURN
    DIVIDE(
        COUNTROWS( 'Invoices' ),
        vIfValue
    )

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      The formula dosent work. Can it be due to the fact that my refference column (Team) is a Custom made column with formula inside?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        selimovd do you maybe know, why it is not working? I cant do reference to a column in this part of your code:

           IF(
        'Invoices'[Team] = "A",
        9,
        10

         

        I can make after IF(... reference to another formula or measure....

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    The formula dosent work. Can it be due to the fact that my refference column (Team) is a Custom made column with formula inside?