Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Is there a way to have the RANKX function rank dynamically based on the Date Slicer?
I'm trying to calculate how many times a department has given an item within a timeframe but my measure seems to be looking at the entirety of everything before assigning a rank, ignoring my date slicer that is looking just at this year.
My current measure is:
Hi there.
Mate, please don't expect people to give you a solution if you don't explain the problem fully in enough detail. You really think that we do know what you're trying to achieve giving us the two expressions without any background? Not even giving us an idea about what the (basic) model looks like? By doing so you're just making the chances that someone will pick this up and solve close to 0.
Best
Darek
User | Count |
---|---|
10 | |
8 | |
5 | |
5 | |
4 |