Forum Discussion

Gareth_Hunt's avatar
Gareth_Hunt
Helper II
6 years ago
Solved

Revenue Variance in matrix

Hi Guys new to the forum and my first post.   I would like to calculate the revenue variance for a number of products compared to the sampe period last year. First Rule  - Revenue Variance is defi...
Show and Tell
  • parry2k's avatar
    parry2k
    6 years ago

    Gareth_Hunt well the measure will work whatever period you are filtering on, until there is something I don't know about the model.

  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi, Gareth_Hunt 

     

    Do you have resolved it? If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.

     

    Best Regards,
    Community Support Team _ Eason

parry2k's avatar
parry2k
Super User
6 years ago

Gareth_Hunt add measure for REV_VAR total

 

REV-VAR Total = 
SUMX ( VALUES ( Table[Product] ), [Rev-Var Measure] )

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

 

 

  • Gareth_Hunt's avatar
    Gareth_Hunt
    Helper II
    6 years ago

    Hi Parry 2K,

     

    thank you for your quick response -

     

    Im sorry i do not fully understand your expression "values (table[Product])"

     

    How do i create the table referenced [product]  # new to Power BI

     

    many thanks 

    Gareth

     

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      Gareth_Hunt whatever column you are using for product a, b, c , use that in values function.

       

      I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

      ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

      • Gareth_Hunt's avatar
        Gareth_Hunt
        Helper II
        6 years ago

        Hi Parry

         

        Really appreciate you helping me -one step closer thats great -still not quite right though

        I think it may be the product table is over multiple years  and of course im only interested in a time period im currently controlling using a Month slicer

         

         

        Many thanks 

         

        Gareth