Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need help with summarize function to sync up data between two charts

Hi All,

I have created two Charts , one based on FG and another one is based on brand.
In Brand , we have a benchmark brand to which other brands prices are compared against it.

 

Calculation goes as below.

 

First taking the average without benchmark

Price not NSC = CALCULATE(AVERAGEX('Sheet1', 'Sheet1'[Price]), 'Sheet1'[Brand] <> "Benchmark")

 

Then taking the average for benchmark alone

Price NSC = CALCULATE(AVERAGEX('Sheet1', 'Sheet1'[Price]), 'Sheet1'[Brand] = "Benchmark")

 

Index value is calculated based on above dax , please refer the sample pbix in the link below.

 

In FG Chart :   Grouping done by FG, Brand

In Brand Chart :  Grouping done by Brand

 

the average of the index values in FG Chart is not the same as Brand Chart.

 

In the sample attached, average of FG chart( 89+ 62 = 151/2 = 75.5)
average of Brand chart ( 82 + 63 = 145/2 = 72.5)

 

Is there any possibility to groupby FG, Brand together in the both the Charts so that the final average is the same in both the visualiations i.e 75.5 . pbix sample available in the below link.

https://drive.google.com/file/d/1z_D1mhknn-o1bkr25B7ZBevdn20n4ECp/view?usp=sharing 

Need Help

3 Replies

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Community Support
    3 years ago

    Hi Anonymous ,

     

    I'm a little confused about your expected output. Can you tell me what's your expected output?

     

    Thanks for your efforts & time in advance.

     

    Best regards,

    Yadong Fang

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Yadong,

    I hope you are able to download the sample pbix in the link that was provided.
    If you see the Chart1 is grouped by FG, Brand together in the dax . Index values for each FG is 89 and 62. Average of 89, 62 is 75.5
    Similarly, Chart2 is grouped by Brand in the dax. Index values for each brand is 82 and 63 . Average of 82, 63 is 72.5

    I want Chart2 to also be grouped by FG,Brand together in the dax so that the final average is 75.5 , same as Chart1.

    • v-yadongf-msft's avatar
      v-yadongf-msft
      Community Support
      3 years ago

      Hi Anonymous ,

       

       

      Actually, [Index_Brand] for brand and [Index_FG] for FG are both 72.33. I think it is not possible for Chart2 to also be grouped by FG,Brand together in the dax so that the final average is 75.5 .

      Best regards,

      Yadong Fang

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.