Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi @_AAndrade ,thanks for the quick reply, I'll add further.
Hi @Sanmaya1 ,
The Table data is shown below:
Please follow these steps:
1. Use the following DAX expression to create a table
Table 2 = GENERATESERIES(0,2000,500)
2.Use the following DAX expression to create a measure
Measure =
VAR _a = SELECTEDVALUE('Table 2'[Value])
VAR _b = DIVIDE(SUM('Table'[Cost]),SUM('Table'[Kgs]),0)
RETURN _b * _a
3.Final ouput
Hi @_AAndrade ,thanks for the quick reply, I'll add further.
Hi @Sanmaya1 ,
The Table data is shown below:
Please follow these steps:
1. Use the following DAX expression to create a table
Table 2 = GENERATESERIES(0,2000,500)
2.Use the following DAX expression to create a measure
Measure =
VAR _a = SELECTEDVALUE('Table 2'[Value])
VAR _b = DIVIDE(SUM('Table'[Cost]),SUM('Table'[Kgs]),0)
RETURN _b * _a
3.Final ouput
the x axis has Kgs value and the y axis has cost .. the lines are showing th cost by KG per services.
Could you please share some data so I could try to understand your need?
Proud to be a Super User!
Hi @Sanmaya1,
Could you describe in more detail your issue or needs?
Proud to be a Super User!