Forum Discussion

emarome94's avatar
emarome94
Helper I
3 years ago
Solved

Summarizing - Grouping values in a calculate table

Hi guys,   Please need your help in this topic.    I have a star schema with classic sales/cost/volume values as a fact table and some other dimension table with product, time, country, ecc.    ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • johnt75's avatar
    johnt75
    3 years ago

    Try

    Tabella =
ADDCOLUMNS (
    SUMMARIZE (
        'Fact Table',
        Dim_Date[FP Month Number],
        Dim_Country[Country],
        FactTable[Customer N],
        FactTable[Customer],
        FactTable[P&L Line ],
        FactTable[Material N],
        Dim_Material[Material Desc]
    ),
    "FY2022 Revenue", CALCULATE ( [Revenue], Dim_Date[Fiscal Year] = "FY2022" ),
    "FY2023 Revenue", CALCULATE ( [Revenue], Dim_Date[Fiscal Year] = "FY2023" ),
    "FY2022 Quantity", CALCULATE ( [Volume], Dim_Date[Fiscal Year] = "FY2022" ),
    "FY2023 Quantity", CALCULATE ( [Volume], Dim_Date[Fiscal Year] = "FY2023" ),
    "FY2022 COGS", CALCULATE ( SUM ( ICMI[COGS] ), Dim_Date[Fiscal Year] = "FY2022" ),
    "FY2023 COGS", CALCULATE ( SUM ( ICMI[COGS] ), Dim_Date[Fiscal Year] = "FY2023" )
)
johnt75's avatar
johnt75
Super User
3 years ago

Try

Tabella =
ADDCOLUMNS (
    SUMMARIZE (
        'Fact Table',
        Dim_Date[FP Month Number],
        Dim_Country[Country],
        FactTable[Customer N],
        FactTable[Customer],
        FactTable[P&L Line ],
        FactTable[Material N],
        Dim_Material[Material Desc]
    ),
    "FY2022 Revenue", CALCULATE ( [Revenue], Dim_Date[Fiscal Year] = "FY2022" ),
    "FY2023 Revenue", CALCULATE ( [Revenue], Dim_Date[Fiscal Year] = "FY2023" ),
    "FY2022 Quantity", CALCULATE ( [Volume], Dim_Date[Fiscal Year] = "FY2022" ),
    "FY2023 Quantity", CALCULATE ( [Volume], Dim_Date[Fiscal Year] = "FY2023" ),
    "FY2022 COGS", CALCULATE ( SUM ( ICMI[COGS] ), Dim_Date[Fiscal Year] = "FY2022" ),
    "FY2023 COGS", CALCULATE ( SUM ( ICMI[COGS] ), Dim_Date[Fiscal Year] = "FY2023" )
)
emarome94's avatar
emarome94
Helper I
3 years ago

hi johnt75 ,

 

No works, still same issue

  • johnt75's avatar
    johnt75
    Super User
    3 years ago

    can you share a screenshot of the dataview for my code please, I want to see what the raw table looks like.

    • emarome94's avatar
      emarome94
      Helper I
      3 years ago

      It was working, my mistake. Thank you

       

      ES