Time Intelligence multiple tables

[loafers]

Hi,

I'm having issues with doing time intelligence measures with multiple tables. 

Basic set up - fact table, date table, and another table with client and date.

Fact table has relationship with third table based on client.

I want to have an option for user to select MTD/QTD/YTD to get the revenue (this is already done). In addition, I also want to get the distinct count of the client and the date the revenue associated with that client was first booked. I attached a sample file and you can see that the count matrix is returning 7 for everything which isn't correct. It should show clients A to D in January and clients E to G in April. For QTD June, I want to see count of 3 (for clients E to G). For YTD June, I want to show a count of 7, for clients E to G. 

Google Drive link to pbix file 

[amitchandak]

@loafers , refer My blog

https://medium.com/chandakamit/power-bi-when-i-felt-lazy-and-i-needed-too-many-measures-ed8de20d9f79

Old solution

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

field parameter can also help

https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...

calculation group can also help

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display: https://youtu.be/qMNv67P8Go0