cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Need help with filters for dax

I am trying to rank items in a data set based on several variables. I have so far used

 

so index = IF(
    SELECTEDVALUE ('Slot Detail v2 %28auto%29'[prog State Code] ) <> 3,
RANKX (
    FILTER (
        'Slot Detail v2 %28auto%29',
        EARLIER ( 'Slot Detail v2 %28auto%29'[Staff Number] ) = 'Slot Detail v2 %28auto%29'[Staff Number]
            && EARLIER ( 'Slot Detail v2 %28auto%29'[Start Date] ) = 'Slot Detail v2 %28auto%29'[Start Date]
            && EARLIER ('Slot Detail v2 %28auto%29'[TCID]) = 'Slot Detail v2 %28auto%29'[TCID]
           
    ),
    'Slot Detail v2 %28auto%29'[Start Time],
    ,
    ASC
)) 

 

This works to a point but i also need the if statement to evaluate futher.

 

I would normally (in crystal reports) use a formula such as

 

If ('Slot Detail v2 %28auto%29'[prog State Code] ) <> 3 and

           (if('Slot Detail v2 %28auto%29'[Activity code]) =blank and if('Slot Detail v2 %28auto%29'[slot State Code] <>3) then

RANKX (
    FILTER (
        'Slot Detail v2 %28auto%29',
        EARLIER ( 'Slot Detail v2 %28auto%29'[Staff Number] ) = 'Slot Detail v2 %28auto%29'[Staff Number]
            && EARLIER ( 'Slot Detail v2 %28auto%29'[Start Date] ) = 'Slot Detail v2 %28auto%29'[Start Date]
            && EARLIER ('Slot Detail v2 %28auto%29'[TCID]) = 'Slot Detail v2 %28auto%29'[TCID]
           
    ),
    'Slot Detail v2 %28auto%29'[Start Time],
    ,
    ASC
)) 

 

 

 

Any idea how to get the rest of the if statement in there?

 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors