Count the number of Occurence without Blank value

[zzzsharepoint]

Hi I have table where I have data like this

Column1

aa

ss

aa

ss

bb

I need the occurence of each value like aa-2 , ss-2 bb-1 and i do not need occurence of blank values. How can I do that?

Thanks

[Anand24 · Accepted solution]

Hi @zzzsharepoint ,
Please use below DAX in a calculated measure:

Count with NO Blank = IF(MAX('Table'[Column1]) <> BLANK(),COUNT('Table'[Column1]),"")

Result:

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn