Forum Discussion

SachinC's avatar
SachinC
Helper V
9 years ago

Percentage DAX Formula

Hi, I want to create a percentage figure, i.e. x%, from two text fields. It's basically calculating click through rate as a %. I've got a count of my audience for a mailshot in a column, a count of...
Need Help
Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

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.

 

SachinC's avatar
SachinC
Helper V
9 years ago

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

 

What do I modify it to please?

  • Sean's avatar
    Sean
    Community Champion
    9 years ago

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

     

     

    Hope this helps! :smileyhappy:

  • SachinC's avatar
    SachinC
    Helper V
    9 years ago

    Didn't work.  Good effort though.

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    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

  • SachinC's avatar
    SachinC
    Helper V
    9 years ago

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

  • SachinC's avatar
    SachinC
    Helper V
    9 years ago

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

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi SachinC,

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

    Best Regards,
    Angelia

  • SachinC's avatar
    SachinC
    Helper V
    9 years ago

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

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi SachinC，

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

    Thanks,
    Angelia