Forum Discussion
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 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 )
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.
4 Replies
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.
godbless you brother . it work 100 % thank you very much
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
