Forum Discussion
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" ...
try:
Measure = VAR _Count=COUNTROWS('Table') RETURN SWITCH(TRUE(), _Count > 9, 300, _Count >= 6, 200, _Count >= 3 ,100, _Count = 2, 75, 50)
