Slicing a visual by a count measure from another visual

[Anonymous]

I have a table with some values set to 0.  I also have a bar chart that has 10 calculated measures that count each columns total of zeros.  When I select one of these calculated measures on the bar chart, the other visuals do not update to the values that only have 0.

I understand there are some issues with slicing by a calculated measure, but is there any workaround for this?

Here is what one of those calculated measures looks like: 

Count of Column for 0 =

CALCULATE(COUNT('Table'[Column]), 'Table'[Column]="0")

[amitchandak]

---

@Anonymous wrote:

.  When I select one of these calculated measures on the bar chart, the other visuals do not update to the values that only have 0.

---

Do you want to use this calculation as a filter?

[Anonymous]

---

@amitchandak wrote:

---

@Anonymous wrote:

.  When I select one of these calculated measures on the bar chart, the other visuals do not update to the values that only have 0.

---

Do you want to use this calculation as a filter?

---

@amitchandak 

Yes. I would like for it to update the table visual that I have to contain only the values that contain 0.

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

Do you want to click on the B bar and left table visual left only the row that column=0 and category = 0?  When you click the B bar, it actually give a filter that category=B to the table visual.

We suggest that you can use the slicer visual and put the column field.

BTW, pbix as attached.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-lid-msft I ended up doing this.  I have multiple 'count for column for 0' measures though, so I had to have a slicer for each (around 10).  Not ideal, but it got the job done.

[amitchandak]

I think you need a flag. create it has a column

Flag = IF (table[value] =0 ,"Zero Value","Non Zero Value").

You might need a bi-directional join, in case this a central/child/fact table and you want to filter parent/dimension table