Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have one dimension table called Dim_SegmentManagerEmployee which has a many to one relationship with Dim_Segment. In a matrix, the rows include Dim_SegmentManagerEmployee[Segment], Dim_SegmentManagerEmployee[Manager], and Dim_SegmentManagerEmployee[Employee]. The value in the matrix is SUM(Fact_Table1[Target]). However, I need to display all values as zeros instead of BLANK() thus I created a measure which is Measure_Target=0+SUM(Fact_Table1[Target]). Let's say I have 3 segments called "Commercial", "Retail" and "Residential".
Case 1: If I have a slicer to select Dim_SegmentManagerEmployee[Segment] at the top of the page. It works fine.
Case 2: However, due to other reasons I have to use the slicer of Dim_Segment[Segment] (The relationship from Dim_SegmentManagerEmployee to Dim_Segment is many to one and single direction). In this case, if my measure is Measure_Target=SUM(Fact_Table1[Target]), it works and only selected segment will be displayed. However, I have to display all BLANK value as zero. If my measure is Measure_Target=0+SUM(Fact_Table1[Target]) and select Dim_Segment[Segment]="Commercial" on the slicer. Only the segment of "Commercial" should be displayed on the matrix but other segments ("Retail" and "Residential") are also displayed (and the values are zero).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.