topic Help! I need a negative value from a basic QUICK MEASURE division in DAX Commands and Tips

Help! I need a negative value from a basic QUICK MEASURE division

Anonymous — Thu, 22 Jul 2021 14:13:53 GMT

Hello!

I have a basic inquiry into how to derive a negative value to eliminate this negative here: (I have been covering the - up with a white space so far but that is not the solution)

% of Measure Not Met =

calculate(DIVIDE(

COUNTA('Safety_01_Num'[PreHospital_Report]),

COUNTA('Safety_01_Denom'[PreHospital_Report])

)* 100-100)

Do I need to make this a variable then multiple it by -1 or can't I just do it here?

Re: Help! I need a negative value from a basic QUICK MEASURE division

Anonymous — Thu, 22 Jul 2021 14:35:38 GMT

never mind...I just added a 0- to before Calculate

Re: Help! I need a negative value from a basic QUICK MEASURE division

Anonymous — Thu, 22 Jul 2021 16:29:52 GMT

And what purpose does the CALCULATE function serve in your expression?