cancel
Showing results for
Search instead 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
Regular Visitor

## 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) ,

CALCULATE( [Your Measure], ALL( [Your Table] ) ),

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".
Highlighted
Regular Visitor

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

Regular Visitor

## Re: Card display Percentage of Total

Use COUNTROWS rather than COUNT

## Helpful resources

Announcements

#### Community Highlights

Find out what's new in the Power BI Community!

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 310 members 3,378 guests
Recent signins:
Please welcome our newest community members: