Forum Discussion

Sax's avatar
Sax
Helper I
3 years ago
Solved

Breakdown by quarter

Hi community, I got a simple model with a fact table, a dimension table and a calendar   I'd like to achieve the breakdown by quarter within each year like in the table below: How do ...
Need Help
  • Sax's avatar
    Sax
    3 years ago

    I figured this out - the right measure to use is 

     

    QuarterBreakdown =
    VAR YearSales =
        SUMX (
            VALUES ( 'Calendar'[Year] ),
            CALCULATE ( [1. Total Sales], ALLSELECTED ( 'Calendar' ) )
        )
    RETURN
        DIVIDE ( [1. Total Sales], YearSales )

Sax's avatar
Sax
Helper I
3 years ago

I figured this out - the right measure to use is 

 

QuarterBreakdown =
VAR YearSales =
    SUMX (
        VALUES ( 'Calendar'[Year] ),
        CALCULATE ( [1. Total Sales], ALLSELECTED ( 'Calendar' ) )
    )
RETURN
    DIVIDE ( [1. Total Sales], YearSales )