Forum Discussion
Card visualizer count distinct without blank
I have card visualizer that count disctict values in a single colunm, However, it calculates blank value that I want to exclude.
I tried to use visual filter but the dropdown of the filter is not clickable.
Hi Haya,
Please try to create one measure as below:
Measure = CALCULATE(DISTINCTCOUNT('Table'[Name]),NOT(ISBLANK('Table'[Name]))&&TRIM('Table'[Name])<>"")
Best Regards
Rena
8 Replies
The information you have provided is not making the problem clear to me. Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
Thanks.
My Recent Blog -
Time Intelligence - Direct QueryName ID Sara 1 Haya 2 Hana 3 Haya 1 Hana 3 When I use "card" visualizer, count distinct Name, the output become 4 because it calculates the empty cell (blank). the output should be 3.
Try
calculate(distinctcount(Table[Name]),not(isblank(Table[Name])))Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin
