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

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
Community 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
    Helper 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
      Community Champion
      9 years ago

      SachinC

       

      Please show me the result of CountClicks..

       

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

      • SachinC's avatar
        SachinC
        Helper V
        9 years ago

        Hi,

        See attached. It's as if it's putting extra lines in for the same values and making % = 1.00.

        Pls help.

        Thanks

        .