Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Creating a variance and displaying correctly

I have two total sales amounts - one for 2017 and one for 2018 that I am creating on the fly. I am using the following formula to create a % variance between the two numbers  -

 

Qty% =
(DIVIDE (
    CALCULATE ( SUM ( table_PowerBI_FinishedGoods[Order Qty] ), table_PowerBI_FinishedGoods[Year] = 2018 ),
   CALCULATE ( SUM ( table_PowerBI_FinishedGoods[Order Qty] ), table_PowerBI_FinishedGoods[Year] = 2017 )  
) -1)  

 

I am computing the correct value but when I display the three columns in a matrix (2017 - 2018 - Qty%) it displays as follows -

 

2017   qty%    2018   qty%

xxx       xx          xxx    xx

 

The same qty% value displays twice -  once  next to each year.  If I use the 'table' visual, it displays as two lines.

 

The question is how I can display the 'qty%' only once per line.

 

Thanks for looking at this.

1 Reply

  • ChandeepChhabra's avatar
    ChandeepChhabra
    Impactful Individual

    Hi Anonymous

     

    Please modify the measure

     

    =DIVIDE( [2018 Measure] - [2017 Measure], [2017 Measure])

     

    I am hoping it should work correctly