Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Function based on filter and columns on a same table

Hello everyone,    I'm new user of Power BI and Dax. I'm writting to you because of a problem I can't achieve to solve.    I have a table with all my data and particularly those variables : Cycle...
  • Cmcmahan's avatar
    7 years ago

    I'm not sure exactly what you're asking for here. Your [Unitary_Mix] measure looks like it should work. What incorrect results are you seeing, and what are the expected results?

    In the first example, would you want to display 2.7 in the row instead of 102.2? Or would you want to display both 102.2 and 2.7 values next to each other in the matrix?

     

    For the second example, do you want the total column to be the difference between the other two?  Or do you want the second column to be the difference from the first column?  Do you want this as another sub-column?  

     

    I'm assuming each entry is an aggregated average, but I can't tell much more than that.  Is it possible for you to share your data with us?  Even a smaller subset of anonymized data with desired output values would be very helpful here. The ability to copy paste your data makes it much easier to develop prototypes.