Forum Discussion
Sanmaya1
2 years agoFrequent Visitor
Need help in creating the chart attached
Hi , i need help or idea to create a chart attached.
- Anonymous2 years ago
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 tableTable 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 * _a3.Final ouput
Anonymous
2 years agoNot applicable
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