Forum Discussion
Solved
Power Bi Desktop - Creating measure from multiple data inputs
Another question helpful people! I'm trying to add these 3 data points to get a total.. and the DAX formula that I'm using is coming out all messed up. TA = SUMX('RawData', RawDATA[Total Assem...
I figured out the issue to my problem.
Total Parts Good = [Total Assemblies for Above Cell During Selected Shift]+[Total CUT TO LENGTH pieces for Above Cell During Selected Shift]+[Total PARFLEX pieces for Above Cell During Selected Shift] worked for me butTAS = SUMX('RawData', RawDATA[Total Assemblies for Above Cell During Selected Shift]+RawDATA[Total CUT TO LENGTH pieces for Above Cell During Selected Shift]+RawDATA[Total PARFLEX pieces for Above Cell During Selected Shift]) --- would come out all wacky. I think it was because I created the measure in "RawDATA" but I was pulling everything else from "Table1"
Once I deleted the old measure and created it in "Table1" everything came out correct.