Calculate Distinct Count of Rows in Table Visual with Filters

[Anonymous]

Hello everyone,

I am stucked in workarounds.... now want hear some expertise from community members for a proper solution.

So I have a `Table View`, and users want to see how many rows are there based on selection of filters.

Since Table view does not calculate distinct count of rows, so I made a `Card View` and passed `Count Distinct ()` in it, which solved the problem in the day.

And now a new requirement comes up. People want to filter a measure. I add the measure at the sidebar.

Which cause a problem as, my standalone card is not filtered by the filter on sidebar.

Hope I stated clearly, anybody be cumbered in the same place before?

Best regards 

[v-jingzhang · Accepted solution]

Hi @Anonymous 

If you put the measure as a filter on the table visual, you can also put it as a filter on the card visual. Or if you hope this filter to take effect on the whole page, you can also put this measure in Filters on this page so that it can filter all visuals on the page.

Another option is to add the filter to your DAX codes for the measure so that it is possible to influence the measure directly. If you want to realize that in this way, can you share some dummy data and expected result in table format or other copiable format thus we can help modify the measure?

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[Ashish_Mathur]

Your question is not clear.  Please offer a detailed/better explanation.