Forum Discussion

lboldrino's avatar
lboldrino
Icon for Resolver I rankResolver I
5 years ago
Solved

Rebuild Excel Measures in Powerbi

Hi. i try to rebuild a excel in powerBI.     Country Sales Target Budget DE 198 313 800 211 151 483 AT 59 737 000 60 895 812 CH 30 227 467 29 684 932 IT 73 839 000 88 879 ...
Need Help
  • lboldrino's avatar
    lboldrino
    5 years ago
    Solution: 🙂
     
    TotalSales EUR =
    GROUPBY(
    FILTER (
    'Sales Target',
    'Sales Target'[Region] <> BLANK ()
    ),
        'Sales Target'[Region],
        'Sales Target'[Country],
        "Total Sales EUR",sumx( CURRENTGROUP(), 'Sales Target'[Sales Target EUR])
    )
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

You need to add a "Region"  column.

  • lboldrino's avatar
    lboldrino
    Icon for Resolver I rankResolver I
    5 years ago
    Solution: 🙂
     
    TotalSales EUR =
    GROUPBY(
    FILTER (
    'Sales Target',
    'Sales Target'[Region] <> BLANK ()
    ),
        'Sales Target'[Region],
        'Sales Target'[Country],
        "Total Sales EUR",sumx( CURRENTGROUP(), 'Sales Target'[Sales Target EUR])
    )