The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!