Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Divide table column by measure

Hi, I have this table with sample data:     I need to create a column that has the following logic:    Real / Actual Venta Bruta   it means that the first row would be 1, and the second ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    @milomilo , you cannot create a new column that uses measure. So you have to do using two columns or create a measure.

negi007's avatar
negi007
Community Champion
5 years ago

Anonymous You can create a measure like below. Modify as per your dataset

 

Real / Actual Venta Bruta = SUM(Real[real])/CALCULATE(SUM(Real[real]),Real[Column]="A")