Incorrect Total using hard coded value

[lhall37122]

I have a measure that I am using an if isblank function and for the true side of it I am setting the value to a hard coded amount such as 80 as shown below. But when I put this into a table visual the total at the bottom is pulling in the same 80 figure. I can't seem to determine the best way to get the actual sum of the Measure. I feel like I should have another measure that peforms the equivilent to a SUMX but could be wrong. Any insight would be greatly appreciated. 

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, but please try the below if it suits your requirement.

Clinic Director Hours =
VAR _Hours = 80
VAR _result =
    SUMX (
        VALUES ( tablename[columnname that is used in the visual] ),
        IF ( ISBLANK ( [Payroll Hours] ), _Hours, [Payroll Hours] )
    )
RETURN
    _result

[lhall37122]

Think you resolved the issue, much appreciate the guidance.