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 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.

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
)

2 Replies

  • 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:

     

     

  • o59393's avatar
    o59393
    Post Prodigy
    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
)