Forum Discussion

anglefbi11's avatar
anglefbi11
Helper I
2 years ago
Solved

clustered column chart include and exclude

hi dears   i want to create clustered column chart    i have the below data       i need to insert two columns chart to compare between car type (    in the first column i need to ins...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Thank you for your prompt reply! Anonymous 

    Hi anglefbi11 

    You'll need to create two DAX measures to calculate the values for each of your columns. The first measure will sum up the values for all cars except Nissan, and the second measure will sum up the values for Nissan only.

    All Cars Except Nissan = CALCULATE(SUM('Table'[value]), 'Table'[Cars] <> "nissan")
    Nissan only = CALCULATE(SUM('Table'[value]), 'Table'[Cars] = "nissan")

     

     

    Result:

     

     

     

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thank you for your prompt reply! Anonymous 

Hi anglefbi11 

You'll need to create two DAX measures to calculate the values for each of your columns. The first measure will sum up the values for all cars except Nissan, and the second measure will sum up the values for Nissan only.

All Cars Except Nissan = CALCULATE(SUM('Table'[value]), 'Table'[Cars] <> "nissan")
Nissan only = CALCULATE(SUM('Table'[value]), 'Table'[Cars] = "nissan")

 

 

Result:

 

 

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

  • anglefbi11's avatar
    anglefbi11
    Helper I
    2 years ago

    godbless you brother . it work 100 % thank you very much