cancel
Showing results for
Did you mean:
Frequent Visitor

## Card display Percentage of Total

Hello,

I have something really simple, yet can't solve for it easily.

I have a collumn, with two choice values "1" and "0".

The card displays the count of the "1", which for this example is 200.

Now I would like the card to show the percentage the "1" value is of the total, so there are 200 "1" and 800 "0", for it to display 20%.

1 ACCEPTED SOLUTION

Accepted Solutions
Established Member

## Re: Card display Percentage of Total

Hi there,

This is just a basic measure.

Calculate(count(COLUMN); COLUMN = "1")

/

count(Column)

--> then just change type to %

10 REPLIES 10
Member

## Re: Card display Percentage of Total

In the measure your using, use CALCULATE in conjunction with ALL or ALLSELECTED, depending on your needs

DIVIDE( CALCULATE( COUNTROWS( [Table Containing Data] ), [Column] = 1) ,

0)

Established Member

## Re: Card display Percentage of Total

Hi there,

This is just a basic measure.

Calculate(count(COLUMN); COLUMN = "1")

/

count(Column)

--> then just change type to %

Frequent Visitor

## Re: Card display Percentage of Total

Hey,

thanks, but something seems to go wrong:

PercentageCalculation =
Calculate(count(table[column1]); [column1]="1")
/
count([column1])

Doesn't work. Mentions "syntax for ';' is incorrect".
Member

## Re: Card display Percentage of Total

The ; is suppose to be a ,

Established Member

## Re: Card display Percentage of Total

Hi,

Thats becouse I live somewhere else

Replace ";" by ","

If you would use more filters in the report or visual, use the solution below!!

Good Luck!

Frequent Visitor

## Re: Card display Percentage of Total

Thanks, thought of that, but something still seems to go wrong :

PercentageCalculation =
Calculate(count(table[column1]), [column1]="1")
/
count([column1])

Value for 'column1' cannot be determined.  Either 'column1' doesn't exist, or there is no current row for a column named 'column1'. Which is fair, as it's the collumn name, not row name
Established Member

## Re: Card display Percentage of Total

Ofcourse..
You will have to adjust the tablename I used to the tablename you use.
If you plan on using PowerBI more, I can really sggest following link:

https://docs.microsoft.com/en-us/power-bi/guided-learning/

Frequent Visitor

## Re: Card display Percentage of Total

Haha no I did that, I'm just changing the name and collumn names when posting here.

Highlighted
Member

## Re: Card display Percentage of Total

Use COUNTROWS rather than COUNT

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 475 members 5,141 guests
Recent signins: