Forum Discussion

Gab_1983's avatar
Gab_1983
New Member
3 years ago

Historical bands using a column

Hello,   I need to implement many classifications based on different measures (YTD, MTD).  I'm using a column because I need the flexibility to use it also as a filter in a slicer.   The classifi...
DAX
ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Gab_1983 ,

You can try this measure instead:

REVENUES YTD =
VAR t =
    ADDCOLUMNS (
        SUMMARIZE (
            Customer,
            Period[Date],
            Customer[Customer],
            Customer[Class Revenues]
        ),
        "REVENUE",
            CALCULATE (
                SUM ( FactAMT[AMT] ),
                DATESYTD ( Period[Date] ),
                ALLEXCEPT ( Customer, Customer[Customer] )
            )
    )
RETURN
    SUMX ( t, [REVENUE] )

  • Gab_1983's avatar
    Gab_1983
    New Member
    3 years ago

    Hi ERD,

     

    thanks for your suggestion. Effectively in this way it works. So according to you is not the "Class column" the problem but the measure...The problem is that in reality I have a big data model that already includes a lot of measures (more than 200), change the structure of each measure is not feasible. 

     

    I'm trying to find a way to implement multiples classification (based on MTD, YTD figures) considering the selected date.

     

    I know that maybe use a column is not the best approach (I already tried to do the classification with a measure (measure + parametric table with the segmentation) and it works well but then I have the limitation that a measure can't be used in rows or in a slicer) .

     

    Please let me know if you have any other suggestions.

     

    Thanks in advance
    G.