Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a measure which works fine but I want it to display the results dynamically for current year and last 2 years instead of me manually selecting the years
Is it possible?
Heres my current measure:
1. DistinctAccount = DISTINCTCOUNT('AccountTable'[AccountId])
2. AccountMembers= CALCULATE(
[DistinctAccount],
FILTER(
ALLSELECTED('Calendar'[Date]),
('Calendar'[Date] <= MAX('Calendar'[Date])
))
,FILTER(ALLSELECTED(Id_Table[Termination Year]),(Id_Table[Termination Year]>SELECTEDVALUE('Calendar'[Year])))
Please let me know
Thanks
Hi @Anonymous,
I have a measure which works fine but I want it to display the results dynamically for current year and last 2 years instead of me manually selecting the years
I'm not very clear about your requirement "display the results dynamically for current year and last 2 years instead of me manually selecting the years ".
Do you want your measure will show the value without selecting date in slicer?
If it is convenient, could you share some data sample and your desired output so that we could understand your scenario better and get the solution more quickly.
Best Regards,
Cherry
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |