Checkbox is not working as expected - Values are being added up

[lardo5150]

I am pulling some data from SPO that looks like the example below.

My rows are the working hours in CST, so 6 is 6am, 7 is 7am..........

The columns are each day of the week, Sunday through Saturday.

There are two columns for each day.

Use Monday as an example.

The MondayQ column shows how many people are in queue during that hour of the day.

The MondayS column shows how many people are staffed during that hour of the day.

I have impoted this data into PBi, and changed the columns to whole numbers like this:

I created a chart, that will show both the Q and S for each hour of that specifc day.

I have hours and Monday in, and it is working.

This works perfect.

I want to be able to select the day of the week, and it will input on the Yaxis the Qday and SDay, depeding on what we check.

I created a new table:

DaysOfWeek = DATATABLE(
    "Day", STRING,
    {
        {"Sunday"},
        {"Monday"},
        {"Tuesday"},
        {"Wednesday"},
        {"Thursday"},
        {"Friday"},
        {"Saturday"}
    }
)

As a test, I started with Monday.

I created two measures:

vMondayQ = SUM('MainTable'[MondayQ])
vMondayS = SUM('MainTable'[MondayS])

I then created a combined measure.

CombinedValue = IF(
    SELECTEDVALUE(DaysOfWeek[Day]) = "Monday",
    [vMondayQ] + [vMondayS],
    BLANK()
)

 I then removed the two Mondays from the Y-axis and input the Combinedvalue measure.

The problem is it is summing the two values now, instead of showing each one like the example above.

What is the proper syntax to show the two values independantly like I did above?

Or do I have to go at this a different way?

[NaveenGandhi · Accepted solution]

Hi @lardo5150 

Split the combined measure into 2 and use them in the y axis.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!!

[lardo5150]

This was it, thanks!