Forum Discussion

rocku2008_1985's avatar
rocku2008_1985
Helper I
3 years ago

Creating a measure from two columns present in two different fields.

I am new to Power BI. I know how to create a measure between two columns present within a field. But how do I create a measure from two different columns present in two different fields (IVIGUsage and TargetvsActuals?

 

I need to create a measure for gram variance and grams to target. So, could you please help me out? Eallier I had created the measure based on the one field targetvsactual which are as:

%GM_Target = Calculate(
            DIVIDE(
                Sum('TargetVsActuals'[Total_Grams]),
                SUM('TargetVsActuals'[Target_Grams])))
 
Gram Variance = (Sum('TargetVsActuals'[Target_Grams]) - Sum('TargetVsActuals'[Total_Grams]))
 
So this has to be modified. Please help me out.
Need Help
Show and Tell
Tips and Tricks

1 Reply

  • olgad's avatar
    olgad
    Resident Rockstar
    3 years ago

    Hi , 

    if there is a relationship between two tables, then simply
    Gram Variance = (Sum('TargetVsActuals'[Target_Grams]) - Sum('SOC'[Total_Grams]))