clustered column chart include and exclude

[anglefbi11]

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 insert all cars and exclude Nissan

in the second column i need to insert Nissan and exclude the rest of the cars

how do i do that?   ( i dont want to insert filter )

[v-jialongy-msft · Accepted solution]

Thank you for your prompt reply! @3CloudThomas 

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]

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

[3CloudThomas]

each visual on a page can have its own filter. See in the Filter pane to Filter on Visual

[anglefbi11]

hi thank you for your reply

it wont work

because if you could see i have only one column for data. 

i need to inseret two clustered column column in the same visual

so when i use the visual filter it will not work as i expect