cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Japsu Frequent Visitor
Frequent Visitor

Tagging dimension table from fact table

Hey,

 

I have a standard one-to-many relationship between a dimension and a fact table.

 

I need to create calculated column for the dimension table where values are based on whether said dimension appears in a fact table.

 

I would only need 1 or 0 for each row on dimension table, but I can't seem to figure this one out.

 

edited for clarification.

1 ACCEPTED SOLUTION

Accepted Solutions
Japsu Frequent Visitor
Frequent Visitor

Re: Tagging dimension table from fact table

I managed to get the result I was looking for with this.

 

= IF ( ISBLANK ( CALCULATE ( COUNTROWS ( VALUES ( Fact) ) ) ) ; 0 ; 1 )

View solution in original post

3 REPLIES 3
vanessafvg Super Contributor
Super Contributor

Re: Tagging dimension table from fact table

@Japsu are you looking for a column or value?


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Japsu Frequent Visitor
Frequent Visitor

Re: Tagging dimension table from fact table

@vanessafvg I'm looking for a value.

 

One calculated column for dimension table and in that column values 0 or 1 based on the fact table.

Japsu Frequent Visitor
Frequent Visitor

Re: Tagging dimension table from fact table

I managed to get the result I was looking for with this.

 

= IF ( ISBLANK ( CALCULATE ( COUNTROWS ( VALUES ( Fact) ) ) ) ; 0 ; 1 )

View solution in original post

Helpful resources

Announcements
New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,280)