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

 

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.

 

SachinC's avatar
SachinC
Helper V
9 years ago

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.

  • 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