How to display multiple measures at once in a table (created with SWITCH(ALLSELECTED) + slicer ?)

[qmartiny]

Hello,

I hope you can help.

I have set up a slicer + measure combo to display a measure based on quarter selected. 

ex  :

q_select= IF(HASONEVALUE(quarter_select[Measure]),SWITCH(ALLSELECTED(quarter_select[Measure]),"Q1",[Q1#],"Q2",[Q2 #],"Q3",[Q3 #], "Q4", [Q4 #], "YTD",[YTD]))

Currently if the user wants the combined Q I set up YTD to be the sum of all Q.

However I get the ask to display Q1,Q2,Q3,Q4 separately in a table (eachcolumn a quarter).

Any idea how to achieve this ? 

Thanks a lot for your help. 

Quentin

[v-juanli-msft]

Hi @qmartiny 

If you have a table with dates and value column, 

you could create a date table,

date =
ADDCOLUMNS (
    CALENDARAUTO (),
    "year", YEAR ( [Date] ),
    "month", MONTH ( [Date] ),
    "quarter", IF (
        MONTH ( [Date] ) <= 3,
        "Q1",
        IF ( MONTH ( [Date] ) <= 6, "Q2", IF ( MONTH ( [Date] ) <= 9, "Q3", "Q4" ) )
    )
)

add "quarter" from "date table" to the matrix "column" field,

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[qmartiny]

Hi Maggie @v-juanli-msft 

The problem I am facing is that the values I want to show exist only as measures with (CALCULATE(DISTINCTCOUNT, FILTER)) logic.

There is no direct link between a date and a measure for example. The business looks at quarter achievement based on multiple factors.

I have this quarter select measure to toggle between each measure based on slicer.

But now I want to show each measure at once in the same table.

That';s the issue I am facing.

Thanks again

Q

[v-juanli-msft · Accepted solution]

Hi @qmartiny 

You could use two button to switch between each Quarter meausre or all quarter measures to show on a table.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.