Power BI "Table" (distinct rows) should depend on Slicers selection

[Anonymous]

Hi,

I have a sample data with 256 rows & 16 columns. With all columns , I want to create a table (not "Matrix") that should depend on Slicers & other visualizations.
"Code" column has duplicate values. We have to create table with all columns that should show distinct rows based on "Code" column distinct values. "Color" & "Category" are Slicers. 

sample criteria 1) if no filters on Slicers,

table should show 49 distinct rows ("Code" distinct values)

sample criteria 2) if Color = black & Category = bikes

then table should show 10 distinct rows (based on "Code" distinct values)

sample criteria 3) if Color = Red & Yellow (and) Category = "Components"

then table should show 10 distinct rows 

We have a bar chart based on "Class" column items (H, L, M) distinct count (based on "Code" distinct values.)
sample criteria 4) If we select any single bar (Ex: "M") on bar chart then table should show 13 distinct rows related to that Bar (Class) "M"


Note: As there is no upload file option, I couldn't upload the sample file.

[isabella]

Hi @Anonymous 

The first 3 criteria is easy to get.

In the criteria 4，you need to use a measure =  DISTINCTCOUNT('table'[CODE]) as the value of the bar chart

And when you select the bar ，you need to clear the selection on the color and category slicers first.

Best Regards,

Community Support Team _Isabella

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

Write this measure and drag it to your visual

Measure = distinctcount(Data[Code])

Hope this helps.