how to sum a measure

[Amz_123]

Hi Community,

I need a help how to sum a Measure Value, Here in my case Measure Value is multipled by parameter value,

For Example,
                                              Consider, Measure = IF([Measure 2]<1,[Measure 1]*[Measure 2],"")

                                                    here "Measure 1" is parameter value, Measure 2=No of shift

i.e., Graph is drawn against Measure and Year

I need output measure to be sum of no. of shift is less than 1 for given years.

If year 1 < 1, to be count as "1"

  year 2 < 1, to be count as "1", sum will be "2"

 so I need new measure as sum(if[Measure]<1,[Measure 1]*[Measure 2],"")). Please guide if this Possible or not 

Thanks in Advance,
Amz

[Greg_Deckler]

Not entirely certain that I understand your issue. Would be helpful to have sample data and expected output. That being said, typically for something like this, you are going to use SUMMARIZE or ADDCOLUMNS, such as: Measure = VAR __table = SUMMARIZE('Table',[Column],"__mymeasure",[Measure 1]) RETURN SUMX(__table,[__mymeasure]) Basically, you typically need to supply some sort of table context for the calculation of your measure and then sum over that table. It is kind of like my Measure Totals The Final Word: https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907