Created Multi language column header, but cannot sum it so cannot use it in some charts

[Arpad_Bodis]

Created Multi language column header, but cannot sum it so cannot use it in some places in charts.

Created a small example pbix file, so some of you may be able to help me.

Link: https://drive.google.com/file/d/1habhzqRcBEPAq2wzszeaMXaFpDtcPpLw/view?usp=sharing

[Anonymous · Accepted solution]

Hi, @Arpad_Bodis 

You can create new measure, try the following link:

Total = SUM('Products'[Grand Total])

Then put this measure to your field, here is my preview:

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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

[Arpad_Bodis]

Hi!

Thanks for the answer!

I tried that, and now it's clear that I should create a measure (for example: SUM GRAND TOTAL), and also create a new 'Field Parameter' , and modify my 'Field Parameter' to include this measure /just like any other column/ like this : 

Translated SUM Grand Total = {

    ("English SUM Grand Total", NAMEOF('Products'[SUM GRAND TOTAL]), 0, "en"),

    ("Hungarian SUM Grand Total", NAMEOF('Products'[SUM GRAND TOTAL]), 1, "hu")

}

Now I can use this "translated total" in charts, where SUMMING is involved. 

THOUGH I find this method a bit overcomplicated, because in this way I already have 2 field params, and what if I want to COUNT ? --> Then I should create my third field param for this. Is that right?

In the beginning I naively thought I only have to create ONE "translated column" with ONE field parameter, then the summing or counting will be automatic after selecting these functions in other places.... 

So I'm close to accept your solution, just have this final question of SUM / COUNT/ etc will need further field parameters... or not