Adding the Quartile summary

Hi, Can someone help me summarize the Quartiles that I created using a Measure. I have data that has the Customer Resolve Survey score and I created a Quartile using this measure: Res% Q...

Anonymous

Not applicable

2 years ago

Hi Sri_phani ,

I create a table as you mentioned.

Then I create a measure and here is the DAX code.

Measure = 
VAR _Resolve =
    MAX ( 'Table'[Resolve] )
RETURN
    IF (
        NOT ISBLANK ( _Resolve ),
        SWITCH (
            TRUE (),
            _Resolve >= 0.75, "Q1",
            _Resolve < 0.75
                && _Resolve >= 0.5, "Q2",
            _Resolve < 0.5
                && _Resolve >= 0.25, "Q3",
            _Resolve < 0.25
                && _Resolve >= 0, "Q4",
            BLANK ()
        )
    )

I create a color DAX code and put it into the Measure column.

Color = 
SWITCH(
    TRUE(),
    'Table'[Measure] = "Q1", "Green",
    'Table'[Measure] = "Q2", "Blue",
    'Table'[Measure] = "Q3", "Orange",
    "Red"
)