Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Static Measure value which doesn't change based on the selection of other widget

Hello All,

I am showing data on Line and Stack column chart. I would like to have my Line static regardless of the filters changed on the report page. I am attaching sample data for understanding.

Transaction Details 
   
Store IDTrx IdWeekday
952501Monday
953502Tuesday
954503Wednesday
955504Thursday
952505Friday
953506Saturday
954507Sunday
955508Monday
952509Tuesday
953510Wednesday
954511Thursday
Sales Master 
   
 Store IDSECount
 95250
 95320
 95417
 95545

 

Data on the Widget   
Store IdTotal SalesSE CountAverage per Salesexec
9523500.06 
9533200.15 
9543170.18 
9552450.04 

 

Measure Formula

Average per Sales exec = DIVIDE( COUNTA('Transaction Details'[Trx_ID]),CALCULATE(Max(SalesMaster[SECount]))


Widget on the Report


 

 

 

 

 

 

 

 

I want the Black Line viz my Measure Average per Sales Exec to be static. It gets changed if I changed my store selection from the filter. Basically, I want to compare the Global average of sales executives against individual stores but based on the weekday. I am getting the data correct on default selection of all stores but as soon as I select selected store the Blackline also changes. 

Any help from the community will be helpful.

Thanks,
J

Need Help

2 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago
    Average per Sales exec = DIVIDE( COUNTA('Transaction Details'[Trx_ID]),CALCULATE(Max(SalesMaster[SECount]),ALL(SalesMaster))

    Hi Anonymous ,

    Try ALL()
    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Nathaniel_C 

      Thanks for your help. I have tried using ALL function and it didn't work. Let me know if you think of any other option.

      Regards,
      J

      Nathaniel_C wrote:
      Average per Sales exec = DIVIDE( COUNTA('Transaction Details'[Trx_ID]),CALCULATE(Max(SalesMaster[SECount]),ALL(SalesMaster))

      Hi Anonymous ,

      Try ALL()
      Let me know if you have any questions.

      If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
      Nathaniel