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

Hi thanks for that. However, my values for Column A and Column B is text.  I am counting Column A and ColumnB but I want to do an inline percentage. See example below.  33 and 31 are counts of Text fields, I want to put an inline column to divide 31/33= 93.93%

Thanks.

 

ovetteabejuela's avatar
ovetteabejuela
Impactful 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
    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.