Forum Discussion
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 dimensi...
I managed to get the result I was looking for with this.
= IF ( ISBLANK ( CALCULATE ( COUNTROWS ( VALUES ( Fact) ) ) ) ; 0 ; 1 )
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.
I managed to get the result I was looking for with this.
= IF ( ISBLANK ( CALCULATE ( COUNTROWS ( VALUES ( Fact) ) ) ) ; 0 ; 1 )