Filter and compare by departments

[jxp73]

Friends,

I have about 35 departments with my unit. I need to compare their expenditures. When I put department into the line chart it looks terrible. I would like to be able to click the department in the table and have the lines show up to compare. 

I believe this is a filtering but I cant seem to get it right with this: 

SlicerCheck = =if(calculate(distinctcount([SlicerColumn]),allselected([SlicerColumn]))=1,"Y","N")

I dont know where to apply the filter correctly....

Thank you

[mwegener]

Hi @jxp73 ,

has your problem been solved?

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[mwegener]

Hi @jxp73 

try this

SlicerCheck = IF(COUNTX(ALLSELECTED('Table'[SlicerColumn]),'Table'[SlicerColumn]) = 1,"Y"),"N")

Measure = IF(COUNTX(ALLSELECTED('Table'[Department]),'Table'[Department]) = 1,SUM('Table'[Value]),BLANK())

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[JarroVGIT]

Hi @jxp73 ,

Can you explain a bit more about what the problem is? Where are you using the DAX that you are providing? Is it possible to not use a table selection for this but a Slicer selection? You can show a table next to the slicer with values you want your users to be aware of when they are slicing the data, and using a slicer makes sure the other departments are not showing in the line chart. When selecting from a table, you have two disadvantages:

1. You need to hold the Ctrl key to select multiple rows.

2. The other lines are faded but not completely invisible.

Based on what you are sharing I would recommend implementing a slicer somehow and not use a Table visual as a filter mechanic.

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂