Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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!