Forum Discussion
Joining multiple formulas into one
Hi, I have about 4 formulas that I have created seperately that I would love to join together in one formula. The screenshot below, the column test validation 2 is the end result that I want to s...
Use Vars
Test Validation 2 % Calc =
VAR Q10 =
CALCULATE ( COUNT ( Sheet1[Quality] ), Sheet1[Quality] = 10 )
VAR Q9_10 =
CALCULATE (
COUNT ( Sheet1[Quality] ),
Sheet1[Quality] = 10,
Sheet1[Recommended] = 10
|| Sheet1[Recommended] = 9
)
VAR Q10_R9 =
CALCULATE (
COUNT ( Sheet1[Quality] ),
Sheet1[Quality] = 10,
Sheet1[Recommended] <= 6
)
VAR TestVal2 = Q9_10 - Q10_R9
RETURN
TestVal2 / Q10:smileyhappy:
I was too slow Vvelarde got there just before me.
Notice we both use https://www.daxformatter.com/ to make the code more readable.