The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
22 | |
14 | |
14 | |
9 | |
7 |