Date dimension and multiple date columns in fact table in SSAS tabular model.

Description:

In this example we explain that how to get Count of measure where there are multiple Date on a single Fact table in SSAS tabular. Or Dim Date are worked only on active relationship in SSAS Tabular model. Or how to use single Date Dimension in your Model in SSAS tabular model. Or Date Dimension with multiple date column in fact table in SSAS tabular model.

So to achieve or use Date Dimension with multiple date columns in Fact Table in SSAS tabular you have to use USERRELATIONSHIP Function of the DAX.

Below is the example of the USERRELATIONSHIP function in SSAS tabular model.

Measure:

=CALCULATE(SUM(InternetSales[SalesAmount]), USERELATIONSHIP(InternetSales[ShippingDate], DateTime[Date]))