Dax - If statement with true logic that has a condition

[Anonymous]

Hello,

I'm trying to achive the following: 

Metric	Value1	Measure
Test1	0	9999
thisisatest	9999	false
Test3	1234	false

Ive writteh the following DAX formula:

Measure= IF(MAX(Table[Metric]) = "Test1", CALCULATE(SUM(Table[Value]),Table[Metric] = "thisisatest"),false)

It works well if the data source is excel but it doesn't work if I'm using a stored prodedure (SQL Server)

Both are direct imports.

Any idea how I can fix this?

Thanks

[RobbeVL]

Hi there, 
 

---

@Anonymous wrote:

"It works well if the data source is excel but it doesn't work if I'm using a stored prodedure (SQL Server)

Both are direct imports."

Are you using Direct Query or Import?...

If you are using import, there should be any difference in how to calculate a measure.
Check if your datatypes are set up the same.

[Anonymous]

Oh sorry, I'm using import.

My data types are the same in both.

I also tried to assign a variable for the CALCULATE() statement and use that in the IF statement. The variable returns the correct value however if I use the variable in the if statement it only returns a blank cell.

If I use the IF statement and use "123" insteat of the variable it returns "123" as expected

[Anonymous · Accepted solution]

I got it to work 🙂

I had to use a filter in my calculation.

Thank you for you help!