Slicer field issue

[NavaneethaRaju]

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

[HotChilli]

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.