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)
So For instance here is a new logic.
if count is equal to 1 = 50
if count is equal to 2 = 75
if count is between 3 to 5 = 100
if count is between 6 to 8 = 200
if count is greater than 9 = 300
how could I write out the between version.
try:
Measure =
VAR _Count=COUNTROWS('Table')
RETURN
SWITCH(TRUE(),
_Count > 9, 300,
_Count >= 6, 200,
_Count >= 3 ,100,
_Count = 2, 75,
50)