Forum Discussion
hansolo
Helper I
Helper IEquivalent to Set Analysis
Hey there - I am new to Power BI but not BI. I consider myself an advanced Qlik user and I have dabbled with other tools such as Tableau, Spotfire and have general knowledge of programming languages ...
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])
chrisu
Responsive Resident
Responsive ResidentFrom 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])