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
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