Percentage DAX Formula

SachinC

in my test file the CountClicks works Ok.

Let me see:

-Your Click column is Text.

-When No have clicks is a blank row in this column? or have a space or something.  To discard this add a calculated column and put 

Column=Len(ColumnwithClicks) the result to empty rows should be 0.

I think I understand where you are coming from but I am lost.  Can you explain again please.  you are right, the values have blanks. Thanks.

I think I understand where you are coming from but I am lost.  Can you explain again please.  you are right, the values have blanks. Thanks.

SachinC

I just need to discard that are empty values.

Because the CountClicks Dax filter the blanks so if you have 10 rows and 3 are empty the result should be 7. If the result is 10 then not are empty values.

My CountClicks is this:  CountClicks = CALCULATE(COUNTA([Clicks]),FILTER(VPBI_Marketing_MailerStats,[clicks]<>BLANK()))

What do I modify it to please?

Trim and Clean the Column in the Query Editor and then Replace with null

Hope this helps! :smileyhappy:

Didn't work.  Good effort though.

Hi SachinC,

It's weird, I am unable to reproduce why you get the error result. Could you please share your .pbix file for further analysis?

Best Regards,
Angelia

Unfortunately there's a lot of confidential data in my PBIX file. How else can you help me please? Thanks.

Hi, I've managed to anonymise the data. How do I upload an Excel sheet please?

Hi SachinC,

You can upload your anonymise Excel to onedrive. We can download it.

Best Regards,
Angelia

ok, it's now mysteriously working. No idea what happened, but its all looking well. thanks for your help.

Hi SachinC，

You have resolve your issue? If it does, please mark the corresponding reply as answer, which will help more people.

Thanks,
Angelia