cancel
Showing results for
Did you mean:
Penhoat 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
RobbeVL 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
MCornish 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)

RobbeVL 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 %

Penhoat 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
MCornish Regular Visitor

Re: Card display Percentage of Total

The ; is suppose to be a ,

RobbeVL 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!

Penhoat 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 RobbeVL 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/

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

MCornish Regular Visitor

Re: Card display Percentage of Total

Use COUNTROWS rather than COUNT

Announcements Top Kudoed Authors
Users Online
Currently online: 310 members 3,378 guests
Recent signins:
• RossP96 • Vucko • LManning3 • BramvanEerden • zbi • engradnansw • Paulina • glee • blhart216 • mss_powerbi • GWTF • antonsundh • Marko_OK • payalmehakare 