IF Statement - DAX

[Jstrodder]

I thought this would be much simpler than it has turned out to be. Two columns of numbers, each from a different powerpivot table. If one is less than the other, than "Possible", otherwise "" (blank). Maybe a different statement is necessary to achieve the desired result?????

One of dozens of variations I've tried:

Violation22:=if([IIS Name Count]>Licenses[Allowed Servers],"Possible","")

The IIS Name Count field is in a separate table and can have multiple rows with the same IIS name that will be summed to compare against the Allowed servers which is the max # of IIS Names that can exist.

Any insight is SO greatly appreciated.

 

[scottsen]

A bit hard to say, without knowing for sure what is a measure vs column, but... it sorta loos like [IIS Name Count] is a measure (probably a countrows), but Licenses[Allowed Servers] is not... you likely just need to wrap them it in a SUM().