Forum Discussion
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 would be -1.160.229 / 3.335.074 , and so on (always divide by 3.335.074 )
Actual Venta Bruta measure is a calculated sum , filtering by the first line of the report.
How can I achieve this using DAX?
Thanks
@milomilo , you cannot create a new column that uses measure. So you have to do using two columns or create a measure.
2 Replies
- negi007
Community Champion
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") - amitchandak
Super User
@milomilo , you cannot create a new column that uses measure. So you have to do using two columns or create a measure.
