Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a date slicer aswell
My requirement is to get the max of date for every name when slicer is selected aswell.
I was able to get the max of date without slicer but when slicer is selected my logic is not working
CALCULATE(MAX(Orders[Date]), ALLEXCEPT(Orders,Orders[Name]))
but this logic not working when date slicer is active.
I need as below
a 10/1/2023 b 8/28/2023 c 6/15/2023
if slicer is selected for 9/30/2023, I need as below
a 9/1/2023 b 8/28/2023 c 6/15/2023
Any help is appretiated
@ask_kumar , Try a measure like
calculate( max(Orders[Date]), filter(all(Orders), Orders[Name] = max(Orders[Name])))
or
calculate(lastnonblankvalue(Orders[Date], max(Orders[Date])), filter(all(Orders), Orders[Name] = max(Orders[Name])))
User | Count |
---|---|
121 | |
69 | |
66 | |
56 | |
52 |
User | Count |
---|---|
181 | |
85 | |
67 | |
61 | |
53 |