Forum Discussion
Unify two formulas
Hi, I need some help please. I have two formulas and I need to join them in one. 1) The first one is: Limit Rate = VAR NetMargin = DIVIDE( SUM(Tabla1[PYG - Mes]), CALCULATE(SUM(Tabla1[PY...
pfinanciero is it kindly possible to supply a sample pbix please?
Excuse me I'll give a bit of context. The first measure is used to give a rating from 1 to 5 to the net margin according to some preset ranges in another table. Since in the row of totals of the first formula it does not calculate the average grade for me, I had to create the second measure, with which it calculates the average in the row of totals.
My question is these two formulas cannot be joined into one, I attach screenshot of the table with current situation.
Thanks!!