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)
Anonymous
this logic is in conflict with your first one which is equal to 4 = "125.00"
pls clarity the whole logics or you can try to modify the measure like below.
Measure =
VAR _count=COUNTROWS('Table')
return SWITCH(TRUE(),_count<3,75,_count=3,100,_count<5,300,_count>6,225)
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)