Forum Discussion
Equivalent to Set Analysis
From your description, I think what you need is the CALCULATE function. For a description of CALCULATE, see http://www.powerpivotpro.com/2014/03/becoming-one-with-calculate/ and https://msdn.microsoft.com/en-us/library/ee634825.aspx. Your formula would look something like:
NameofMeasure = CALCULATE(SUM([Value]),[Condition]=1) / SUM([Value])
From your description, I think what you need is the CALCULATE function. For a description of CALCULATE, see http://www.powerpivotpro.com/2014/03/becoming-one-with-calculate/ and https://msdn.microsoft.com/en-us/library/ee634825.aspx. Your formula would look something like:
NameofMeasure = CALCULATE(SUM([Value]),[Condition]=1) / SUM([Value])
Smoupre helped as well but Chrisu gave me something exactly like set analysis. I am sure as I get more comfortable with BI I will stop relating it to Qlik but this is really helpful for me to start conceptually understanding Power BI.
Thanks guys!