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...
Hi, you can use variables inside the measure.
My TestValidation 2% =
VAR Quality_10_Score_Count =
CALCULATE ( COUNT ( Sheet1[Quality] ); Sheet1[Quality] = 10 )
VAR Quality_Score_10_and_Recommended_Score_9_or_10 =
CALCULATE (
COUNT ( Sheet1[Quality] );
Sheet1[Quality] = 10;
Sheet1[Recommended] = 10
|| Sheet1[Recommended] = 9
)
VAR Quality_Score_10_and_Recommended_Score_9_10_V2 =
CALCULATE (
COUNT ( Sheet1[Quality] );
Sheet1[Quality] = 10;
Sheet1[Recommended] <= 6
)
VAR Test_Validation_2_Recommended_Score = Quality_Score_10_and_Recommended_Score_9_or_10
- Quality_Score_10_and_Recommended_Score_9_10_V2
RETURN
Test_Validation_2_Recommended_Score / Quality_10_Score_CountRegards
Victor
Lima - Peru
The only thing is I only want to use columns Recommended and Quality inside the calculation. Can you show me how I would do that not using all those pre-created measures. I only want to use the 2 values that are actually inside my dataset. The image below shows the only 2 true data points in the file. Is there a way to get it combined using only those fields?
Variables are an efficient way of getting what you need.
