Slicer Not Working as Intended

[kpansia]

Hey I have a small sample table example below this. When I am creating visualizations, specifically the stacked column chart, I use a slicer to seperate and count distinct values by year. So If I choose 2012, my visualization should show id 1 = 1 in sales year 2012 and id 2 = 1 in Sales year 2012. Instead it is showing up as id 1 = 3 and id 2 = 1. My understanding is that if it sees atleast one id in 2012 it counts all instances of it within in the table. Does anyone know how to change this?

id        |   salesYear|

--------------------|

  1       |     2012    |

  1       |     2013    |

  2       |     2012    |

  1       |     2015    |

[v-huizhn-msft · Accepted solution]

Hi @kpansia,

I reproduce your scenario and get expected result, please follow the steps below.

1. Create a measure using the formula below.

DistinctCount = COUNT(Table2[id])

2. Create a stacked column chart, select the Id as x-axis, the measure as value. Create a slicer including Year field.

select 2012 yearselect 2013 year

Please download the .pbix for reviewing more details.

Best Regards,
Angelia