Forum Discussion

Sanmaya1's avatar
Sanmaya1
Frequent Visitor
2 years ago
Solved

Need help in creating the chart attached

Hi , i need help or idea to create a chart attached.  
  • Anonymous's avatar
    Anonymous
    2 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 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