Forum Discussion
Solved
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 cl...
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
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
I've tried but the same
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