cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Percentage one value appears in another table

Hello,

I'm new in PowerBI, I'm taking the PowerBI Course in EdX to avoid silly questions but I can't get this solution done.

I have a table Blogs and the Table Photos, I want to show the percentage of Blogs that has photos attached. Blogs Table has no indicator about it. You can only see in Photos table the blog ID which that photo is attached if is attached to a blog.

Any suggestion to display the percentage of blogs that has 1 or more photos?

I know the number already by making a distinct count of blog_id in the photo table but I cannot make the Pie chart with the total.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User

## Re: Percentage one value appears in another table

Hello,

@alanhanssen

Use these measures:

Count_BlogwithPhotos = CALCULATE(DISTINCTCOUNT(Blogs[BlogiD]),RELATEDTABLE(Photos))

Count_NoBlogwithPhotos = DISTINCTCOUNT(Blogs[BlogiD])-[Count_BlogwithPhotos]

Finally, Put both measure in chart values.

Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Community Support Team

## Re: Percentage one value appears in another table

Hi, @alanhanssen

Create a measure:

`Count_BlogwithPhotos  = CALCULATE(DISTINCTCOUNT(Blog[Blog_ID]),RELATEDTABLE(Photo))`

Add a calculated column in Blog table:

`Column 2 = IF(LOOKUPVALUE(Photo[Blog_ID],Photo[Blog_ID],Blog[Blog_ID])=Blog[Blog_ID],"Attached","UnAttached")`

Then, thepie chart should be like:

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Super User

## Re: Percentage one value appears in another table

Hello,

@alanhanssen

Use these measures:

Count_BlogwithPhotos = CALCULATE(DISTINCTCOUNT(Blogs[BlogiD]),RELATEDTABLE(Photos))

Count_NoBlogwithPhotos = DISTINCTCOUNT(Blogs[BlogiD])-[Count_BlogwithPhotos]

Finally, Put both measure in chart values.

Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Community Support Team

## Re: Percentage one value appears in another table

Hi, @alanhanssen

Create a measure:

`Count_BlogwithPhotos  = CALCULATE(DISTINCTCOUNT(Blog[Blog_ID]),RELATEDTABLE(Photo))`

Add a calculated column in Blog table:

`Column 2 = IF(LOOKUPVALUE(Photo[Blog_ID],Photo[Blog_ID],Blog[Blog_ID])=Blog[Blog_ID],"Attached","UnAttached")`

Then, thepie chart should be like:

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.