Calculating Percentage by filtering by another measure

[ChrisB1977]

Hi,

I’m trying to create a percentage in PowerBI. I have the following 2 columns in my table:

Views	Targeted
25000	0
25000	0
50000	1

I want to show on a card visual the % of Views that are targeted – so, expressing the fact that 50000 of the Views are marked with a 1 from the Targeted column = 50% of total views. Sorry, may be very simple, but how should I do this?

Many thanks

Chris

[quentin_vigne · Accepted solution]

Hi @ChrisB1977

My idea would be to create a new column with this formula :

Result = IF(Table1[Targeted]=1;DIVIDE(Table1[Views ];SUM(Table1[Views ]));0)

Replace Table1 by your Table name

And in the modelisation section click on the % image to change your 0.5 into 50%

And If you numbers are text add "   " for the 1

Not sure that's the best thing but it works for me

[quentin_vigne · Accepted solution]

Hi @ChrisB1977

My idea would be to create a new column with this formula :

Result = IF(Table1[Targeted]=1;DIVIDE(Table1[Views ];SUM(Table1[Views ]));0)

Replace Table1 by your Table name

And in the modelisation section click on the % image to change your 0.5 into 50%

And If you numbers are text add "   " for the 1

Not sure that's the best thing but it works for me

[ChrisB1977]

Hi @quentin_vigne,

Thanks very much for replying so quickly. I tried the below but keep getting an error stating 'The Syntax for ';' is incorrect' - any ideas why it's doing this?

Many thanks for your help

Chris

[Stachu · Accepted solution]

probably it's different locale try replacing ; with ,

[ChrisB1977]

Thank you @quentin_vigne and @Stachu, a combination of your suggestions worked! Rerally appreciate your help

[quentin_vigne]

It works when I copy your datas on my PBI version

Did you change the table name / column name so that it match yours ?