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
ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
9 years ago

Sample data would help, not sure what you're trying to do but have you tried DIVIDE and format the resulting column to a Percentage?

New Column Name = Divide(Column A,Column B)

 

And then format New Column Name to percentage.

 

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