topic Re: Incorrect Total using hard coded value in DAX Commands and Tips

Incorrect Total using hard coded value

lhall37122 — Wed, 01 Nov 2023 14:25:59 GMT

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.

Re: Incorrect Total using hard coded value

Jihwan_Kim — Wed, 01 Nov 2023 17:52:39 GMT

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

Re: Incorrect Total using hard coded value

lhall37122 — Wed, 01 Nov 2023 19:31:35 GMT

Think you resolved the issue, much appreciate the guidance.