cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
alanhanssen Frequent Visitor
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
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
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:

 

1.PNG

 

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
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
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:

 

1.PNG

 

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.