Forum Discussion

SachinC's avatar
SachinC
Icon for Helper V rankHelper 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
ovetteabejuela's avatar
ovetteabejuela
Icon for Impactful Individual rankImpactful Individual
9 years ago

Would you be able to post a dummy data keeping the table structure?  and also if possible the result desired.

SachinC's avatar
SachinC
Icon for Helper V rankHelper V
9 years ago

See attached. I have manually computed the % value in the pivot, I can't seem to do this in PowerBI. 

All the columns are text, I am doing counts to get numeric values from them.  Thanks.

 

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    9 years ago

    SachinC

     

    Hi, please try with these measures:

     

    CountAudiences = COUNTA(Table1[Audience])

    CountClicks = CALCULATE(COUNTA(Table1[Clicks]),FILTER(Table1,Table1[Clicks]<>BLANK()))

    % = DIVIDE([CountClicks],[CountAudiences])

    • SachinC's avatar
      SachinC
      Icon for Helper V rankHelper V
      9 years ago

      Are you sure the CountClicks formula is correct? The FILTER bit doesn't seem to work.  Please help?  Thank you.

      • Vvelarde's avatar
        Vvelarde
        Icon for Community Champion rankCommunity Champion
        9 years ago

        SachinC

         

        Please show me the result of CountClicks..

         

        it gives you an error or the result is not the correct?