Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |