Forum Discussion

NavaneethaRaju's avatar
NavaneethaRaju
Icon for Helper IV rankHelper IV
3 years ago

Slicer field issue

Hi, 

I have a many to many relationship between two tables. Pbi_csm_case_request_fact, Pbi_csm_case_detail_fact via Case ID column.

I have a surgery date in Pbi_csm_case_detail_fact there, i created Mon-YY field for filtereing data based on Month with Year. If i used a created field in slicer. and using that slicer the i filter sep month it showing only sept month remaining months are disapearing.

(Figure 3)but while using fields from Pbi_csm_case_request_fact table, the slicer was filtered sept month , but oct and nov month was not disappearing its still showing null values.

 

Figure 1:

 

Figure 2:

 

Figure 3:

 

 

 

Measure in using fields from same table- 

report 1(Figure 2):

Cancelled =
    DISTINCTCOUNT(  'Case Detail Fact'[Case ID]),
        'Case Detail Fact'[Case Status] = "Cancelled")

 

report 2(Figure 2):

Lending Cancel =
CALCULATE(COUNT('Case Request Fact'[Request ID]),FILTER('Case Request Fact','Case Request Fact'[Status]="Cancelled"))
 
Please advice
Need Help
Show and Tell
Tips and Tricks

1 Reply

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion
    3 years ago

    I don't think rewriting any measures is going to be helpful.  You need to sort the model first.

    I see that all the relationships are 'both' directions and they all appear to be many-to-many.

    Get yourself a star schema with dimension tables filtering fact table and then write your measures.