Forum Discussion

logistics_power's avatar
logistics_power
Regular Visitor
2 years ago

calculation between two rows to get result

Hi Experts,   I have a matrix visual as below and I would like to calculate Output/ Input = Production recovery % at Process name level Production area Process name Process line name Product...
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
2 years ago

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

 

 

 

 

 

 

  • logistics_power's avatar
    logistics_power
    Regular Visitor
    2 years ago

    Thanks for your response

    My model is something like this. Tables as below

     

    The values Actual, Forecast and Budget M3 are measures existing in the model itself that I am pulling in matrix visual.

    I am not adding anything in the matrix visual columns.

    Values are in the values.

    production area, process name, proces line name, production type are added in this order in the rows section.

    Your model being slightly different, when I add the new measure to the values it is added as a new column at the end in the visual instead of as a row near the input/output.

    Is there any other way we can writ the DAX?

    Thanks