Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX

Hello need help with a formula.    I am trying to create a dax formula based off the below data.    The formula should say if the Sum/Count of the load number in Jan is  less than 3 = "75.00" ...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    try:

    Measure = 
VAR _Count=COUNTROWS('Table')
RETURN
SWITCH(TRUE(),
_Count > 9, 300,
_Count >= 6, 200,
_Count >= 3 ,100,
_Count = 2, 75,
50)
ryan_mayu's avatar
ryan_mayu
Super User
4 years ago

Anonymous 

pls try this

Measure = 
VAR _count=COUNTROWS('Table')
return SWITCH(TRUE(),_count<3,75,_count=3,100,_count=4,125,_count>6,225)

TheoC's avatar
TheoC
Community Champion
4 years ago

ryan_mayu, I did have a solution that has now been deleted given the simplicity of yours 😂!!

Love your work mate!

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    4 years ago

    Thank you