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

 

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

      .

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