Forum Discussion

o59393's avatar
o59393
Post Prodigy
2 years ago
Solved

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 ...
Need Help
Show and Tell
  • o59393's avatar
    o59393
    2 years ago

    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
)
o59393's avatar
o59393
Post Prodigy
2 years ago

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: