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 goe...
Need Help
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.