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.
Go to Solution.
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
@Japsu are you looking for a column or value?
@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.
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!