Really need your help

Hi ham2889,

One sample for your refernce.

1. Create a calculated table as below. Here we needn't create relationship between the new table and the fact table.

Year = VALUES(Table1[Year])

2. Create the measures as below.

Measure = 
var _count = CALCULATE(DISTINCTCOUNT(Table1[Year]),ALLSELECTED(Table1),VALUES(Table1[IDs]))
var _dis = CALCULATE(DISTINCTCOUNT('Year'[Year]))
return
IF(MAX(Table1[Year]) in VALUES('Year'[Year]),CALCULATE(DISTINCTCOUNT(Table1[IDs]),FILTER(ALLSELECTED(Table1[Year]),_count=_dis)))

Measure 2 = CALCULATE(DISTINCTCOUNT(Table1[IDs]),FILTER(Table1,[Measure]<>BLANK()))

For more details, please check the pbix as attached.

Regards,

Frank

Hi ham2889

Below is my solution where I created a very small star schema. This is ideal when creating data models and can easily solve your issue as shown below.

v-frfei-msft solution too works, so you can decide which one works for you.

Here is a link to the PBIX: Really need help