Forum Discussion
Solved
Filtering values only currently present in fact tables
Hi all! the situation: there are two fact tables allocation and demand. when a role is required in a team, it is inserted in the demand table; when a role is allocated to a team, it's in the all...
Try these measures:
Allocation Value = SUM ( Allocation[Value] )Demand Value = SUM ( Demand[Value] )Fact Table Filter = IF ( NOT ISBLANK ( [Allocation Value] ) || NOT ISBLANK ( [Demand Value] ), 1 )In the table visual (which uses fields in the Bridge table), create a visual filter using Fact Table Filter:
Result:
-----
Try these measures:
Allocation Value = SUM ( Allocation[Value] )Demand Value = SUM ( Demand[Value] )Fact Table Filter =
IF ( NOT ISBLANK ( [Allocation Value] ) || NOT ISBLANK ( [Demand Value] ), 1 )
In the table visual (which uses fields in the Bridge table), create a visual filter using Fact Table Filter:
Result:
-----
thanks a lot!! it worked!