Forum Discussion

Arpad_Bodis's avatar
Arpad_Bodis
New Member
1 year ago
Solved

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

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

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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's avatar
      Arpad_Bodis
      New Member
      1 year ago

      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