cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Prodigy

## Modify measure in column

Hi all

I need to remove the column value from X-Axis "Type" and keep it just for the Total.

Below the current state:

Instead I would like to have it like this (light blue column just on totals):

The measure is the following:

``````OU Target =
Var Target =
CALCULATE(
[OU Savings Target],
ALL('Type with total'))
Return
SWITCH(
SELECTEDVALUE('Type with total'[Type]),
"Total",Target,
[OU Savings Target]
)``````

Where Type with total is:

How can I keep the light blue bar just in total x-axis?

Thanks.

1 ACCEPTED SOLUTION
Post Prodigy

I was able to solve it:

Just removed the [OU Savings Target] from the dax code. Final one is:

``````OU Target =
Var Target =
CALCULATE(
[OU Savings Target],
ALL('Type with total'))
Return
SWITCH(
SELECTEDVALUE('Type with total'[Type]),
"Total",Target
)``````
2 REPLIES 2
Post Prodigy

I was able to solve it:

Just removed the [OU Savings Target] from the dax code. Final one is:

``````OU Target =
Var Target =
CALCULATE(
[OU Savings Target],
ALL('Type with total'))
Return
SWITCH(
SELECTEDVALUE('Type with total'[Type]),
"Total",Target
)``````
Post Prodigy

I modified the dax

``````OU Target =
Var Target =
CALCULATE(
[OU Savings Target],
ALL('Type with total'),'Type with total'[Type]="Total")
Return
SWITCH(
SELECTEDVALUE('Type with total'[Type]),
"Total",Target,
[OU Savings Target]
)``````

And the light blue bar dissapeared from the total and remained in the rest, which is the opposite of the solution I am looking for: