Percentage one value appears in another table

[alanhanssen]

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. 

[Vvelarde · Accepted solution]

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.

[v-yulgu-msft · Accepted solution]

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

[Vvelarde · Accepted solution]

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.