Forum Discussion

tomcat2018's avatar
tomcat2018
Regular Visitor
8 years ago
Solved

Power BI - Compare Individual vs Average data per month

Hi, imagine the scenario of sales data per store per month                               Is there any way that I would select a store from Slicer and it would compare its indivi...
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Using Query Editor, you should first unpivot your dataset to ultimately have a 3 column dataset - Store, Month and Sales.  In a visual of your choice, select any Store in the Filter/slicer and write the following measures:

     

    1. Revenue = SUM(Data[Sales])
    2. Total revenue = CALCULATE([Revenue],ALL(Data[Store]),ALL(Data[Month]))

     

    Hope this helps.

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago
Hi tomcat2018

If you create this two measures then you can do a 3rd measure.with difference, division or something like that.

SALES = SUM(Table[sales])
Total sales = CALCULATE ([SALES] : ALL(Table[Store]; Table[Date]))

Since measures are calculated on context if you place this on your visual should work

Regards
MFelix
tomcat2018's avatar
tomcat2018
Regular Visitor
8 years ago

thanks for your help

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    You are welcome.