Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
Following measure works fine with an active relationship.
I need to work with an inactive relationship between Fact X and Dim_Time_startdate.
How can I modify the measure so it works with an inactive relationship.
I found something with userelationship, but don't know how to fit this DAX function in the excisting measure.
Count Active X =
CALCULATE(
COUNT('Fact_X'[StartdateX);
FILTER(
'Fact_X';
'Fact_X'[StartdateDT] <= CALCULATE(MAX(Dim_Time_Startdate
[Startdate (111)]))
);
FILTER(
'Fact_X'; 'Fact_X'[EnddateDT] >= CALCULATE(MIN(Dim_Time_Startdate[Startdate (111)]))
|| 'Fact_X'[EnddateDT] = BLANK());
FILTER(
'Dim_Ycategory';'Dim_YY'[YCode] = "WI"
)
)
Solved! Go to Solution.
@Anonymous,
Do you create inactive relationship between 'Fact_X'[StartdateDT] and Dim_Time_Startdate
[Startdate (111)]? If so, please change your DAX to the following. If the DAX doesn't work as expected, please share sample data of your table and post expected result here.
Count Active X = CALCULATE( COUNT('Fact_X'[StartdateX); FILTER( 'Fact_X'; 'Fact_X'[StartdateDT] <= CALCULATE(MAX(Dim_Time_Startdate [Startdate (111)])) ); USERELATIONSHIP('Fact_X'[StartdateDT],Dim_Time_Startdate [Startdate (111)]); FILTER( 'Fact_X'; 'Fact_X'[EnddateDT] >= CALCULATE(MIN(Dim_Time_Startdate[Startdate (111)])) || 'Fact_X'[EnddateDT] = BLANK()); FILTER( 'Dim_Ycategory';'Dim_YY'[YCode] = "WI" ) )
Regards,
Lydia
@Anonymous,
Do you create inactive relationship between 'Fact_X'[StartdateDT] and Dim_Time_Startdate
[Startdate (111)]? If so, please change your DAX to the following. If the DAX doesn't work as expected, please share sample data of your table and post expected result here.
Count Active X = CALCULATE( COUNT('Fact_X'[StartdateX); FILTER( 'Fact_X'; 'Fact_X'[StartdateDT] <= CALCULATE(MAX(Dim_Time_Startdate [Startdate (111)])) ); USERELATIONSHIP('Fact_X'[StartdateDT],Dim_Time_Startdate [Startdate (111)]); FILTER( 'Fact_X'; 'Fact_X'[EnddateDT] >= CALCULATE(MIN(Dim_Time_Startdate[Startdate (111)])) || 'Fact_X'[EnddateDT] = BLANK()); FILTER( 'Dim_Ycategory';'Dim_YY'[YCode] = "WI" ) )
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
109 | |
89 | |
76 | |
67 |
User | Count |
---|---|
125 | |
111 | |
100 | |
83 | |
71 |