Calculate total and ratio

[MrDarian]

I Want to learn how to write dax code in two ways ( Calculated Column and Measure)

to formulate total by "PriodID" and "Ratio"

[Anonymous · Accepted solution]

Hi @MrDarian ,

Check

Measure 1 = CALCULATE(SUM('Table'[Indicator]),ALLEXCEPT('Table','Table'[PeriodID]))

Measure 2 = SELECTEDVALUE('Table'[Indicator])/[Measure 1]

Column 1 = CALCULATE(SUM('Table'[Indicator]),ALLEXCEPT('Table','Table'[PeriodID]))

Column 2 = 'Table'[Indicator]/'Table'[Column 1]

Best Regards,

Jay

[Anonymous]

Hi @MrDarian :

PFB Calculated column and measure :

CalculatedColumnSum = CALCULATE(SUM('Table'[Indicator]),ALLEXCEPT('Table','Table'[PeriodID]))

CalculatedColumRatio = 
Var _IndicatorByPeriod= CALCULATE(SUM('Table'[Indicator]),ALLEXCEPT('Table','Table'[PeriodID]))
Var _Result= DIVIDE('Table'[Indicator],_IndicatorByPeriod,0)
Return
_Result

MeasureSum = CALCULATE(SUM('Table'[Indicator]),ALLEXCEPT('Table','Table'[PeriodID]))

MeasureRatio = DIVIDE(SUMX(FILTER('Table','Table'[PeriodID]=MAX('Table'[PeriodID])),'Table'[Indicator]),[MeasureSum],0)

Thanks!

[amitchandak]

@MrDarian 

Try

New column = divide([indicator], sumx(filter(table,[PriodID] = earlier([PriodID])),[indicator]))

New measure = divide(sum([indicator]), sumx(filter(allselected(table),[PriodID] = Max([PriodID])),[indicator]))
New measure = divide(sum([indicator]), sumx(filter((table),[PriodID] = Max([PriodID])),[indicator]))

[Ajinkya369]

Hi @MrDarian ,

Please share an example of what calculations you want to perform.

Thank you