DAX

[Anonymous]

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"

greater than or equal to 3 =  "100.00"

greater than or equal to 4 = "125.00"

greater than 6 = "225.00"

other wise Null.

So Jan should give me a sum of 4 Loads and a fee of 125.00

Feb would give me a sum of 2 loads and a fee of 75.00 etc. 

[ryan_mayu]

@Anonymous 

pls try this

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

[Anonymous]

Hello  this is perfect How could I add a between in the formula ? for volume that is between 3 to 5 would equal 300

[ryan_mayu]

@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)

[Anonymous]

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.

[PaulDBrown · Accepted solution]

try:

Measure = 
VAR _Count=COUNTROWS('Table')
RETURN
SWITCH(TRUE(),
_Count > 9, 300,
_Count >= 6, 200,
_Count >= 3 ,100,
_Count = 2, 75,
50)

[TheoC]

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

Love your work mate!

[ryan_mayu]

Thank you