Forum Discussion

shaunbrookes's avatar
shaunbrookes
Frequent Visitor
8 years ago

AllExcept with Filtering

I'm hoping someone can assist me here. I'm coming from Tableau so I'm not sure what I'm trying to do is achievable in PowerBI.   What i'm trying to do is the following:   Step 1) Dashboard User f...
shaunbrookes's avatar
shaunbrookes
Frequent Visitor
7 years ago

Just bumping this up incase anyone can assist

Anonymous's avatar
Anonymous
Not applicable
7 years ago
First Order =
VAR _FirstDate =
    CALCULATE (
        MIN ( FactInternetSales[OrderDate] ),
        ALLSELECTED ( )
    )
RETURN
    IF ( FactInternetSales[OrderDate] = _FirstDate, "yes", "no" )

Try this measure, if it doesnt work then you will need to use the ALLSELECTED measure but adding any columns used as slicers to the exceptions