Forum Discussion

RENJITH_R_S's avatar
RENJITH_R_S
Resolver II
5 years ago

Dax Help : Status Column

Hi Friends, Could you please help me to write the dax query for the status column in the below example scenario Week No is a slicer visual   Input Table     Name Subject Week No ...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

RENJITH_R_S , Create a new measure like

 

Measure =
var _1 = calculate(count([Subject]), filter(allselected(Table),Table[Subject] = max(Table[Subject])))
var _2 = calculate(count([Subject]), filter(all(Table),Table[Subject] = max(Table[Subject])))
return
if(Isblank(_1) && not(isblank(_2)), "left", "available")

  • RENJITH_R_S's avatar
    RENJITH_R_S
    Resolver II
    5 years ago

    amitchandak , I have created your measure but its not working