Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm working on visualizing the updated user journey, and I've come up with a formula that provides accurate results when the full date range is selected. However, I've noticed that the formula doesn't adapt correctly when the date range is narrowed down. Any insights would be greatly appreciated.
Solved! Go to Solution.
Hi @Kreator
Based on your description, please try the following steps:
1. Create a calculated table as follows.
Date = VALUES('Table'[Date])
2. Create several measures as follow.
MaxDate =
CALCULATE (
MAX ( 'Table'[Date] ),
FILTER (
ALLEXCEPT ( 'Table', 'Table'[Journey_ID], 'Table'[Customer_ID] ),
[Date] >= MIN ( 'Date'[Date] )
&& [Date] <= MAX ( 'Date'[Date] )
)
)
Measure = IF(SELECTEDVALUE('Table'[Date]) = [MaxDate], 1, 0)
count = COUNTROWS(SUMMARIZE(FILTER('Table', [Date] = [MaxDate]),'Table'[Journey_ID]))
3. Put the measure into the filter so that the visual only shows data where the measure is equal to 1.
Is this the result you expect?
Best Regards,
Community Support Team _Yuliax
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Kreator
Based on your description, please try the following steps:
1. Create a calculated table as follows.
Date = VALUES('Table'[Date])
2. Create several measures as follow.
MaxDate =
CALCULATE (
MAX ( 'Table'[Date] ),
FILTER (
ALLEXCEPT ( 'Table', 'Table'[Journey_ID], 'Table'[Customer_ID] ),
[Date] >= MIN ( 'Date'[Date] )
&& [Date] <= MAX ( 'Date'[Date] )
)
)
Measure = IF(SELECTEDVALUE('Table'[Date]) = [MaxDate], 1, 0)
count = COUNTROWS(SUMMARIZE(FILTER('Table', [Date] = [MaxDate]),'Table'[Journey_ID]))
3. Put the measure into the filter so that the visual only shows data where the measure is equal to 1.
Is this the result you expect?
Best Regards,
Community Support Team _Yuliax
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |