Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
RobG
Frequent Visitor

RANKX not affected by Date Slicer

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:  

GiveDeptRank = RANKX(ALL(GiveGet[GiveDept]), CALCULATE(COUNT(GiveGet[GiveDept]), ALLEXCEPT(GiveGet, GiveGet[GiveDept])))
 
I've also tried:  
GiveDeptRank = RANKX(ALLSELECTED(GiveGet[GiveDept]), CALCULATE(COUNT(GiveGet[GiveDept]), ALLEXCEPT(GiveGet, GiveGet[GiveDept])))
1 REPLY 1
Anonymous
Not applicable

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

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.