0

my major goal is to calculate Conditional Probability over a large number of rows. Hence the use of Powerpivot. Attached is an excel file with 10 rows as an example of how I did it in Excel. My challenge is the formula in column F which I will then be needing to calculate column G. Tamir

Tamir
  • 33
  • 5

1 Answers1

0

Can you check the solution

Main Formulas: Calculate a Total, without filtering BRAND and UPS (calculated measure)

=CALCULATE([Total],All(Brand),All(upc))

Sum IF UPC (calculated column):

=CALCULATE([Total],filter(ALL(Fact),Fact[UPC]= EARLIER(Fact[UPC]) ))
WimV
  • 1,005
  • 6
  • 11