Forum Discussion

The8's avatar
The8
Helper II
2 years ago
Solved

Table Total Incorrect with Measure A using in New Measure

Hi, I have loaded data into power BI from excel and I have created relationship betweeen tables using currency column. Sheet 1 Sheet 2 Now I have following measures Final Price...
Need Help
The8's avatar
The8
Helper II
2 years ago

Hello Greg_Deckler 

 

Is that possible even when I take material into a table or matrix in my case?

Thanks !!

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    2 years ago

    The8 I don't think that you are taking the time to read up on this issue, particular the second link I posted that goes through the issue in detail and how to fix it. If you include additional columns in your table visual, you have to add those columns to your SUMMARIZE like this:

    Final Price Total = 
    VAR __Table = SUMMARIZE( 'Sheet1', [Date],[Material], "__Value", [Final Price in €])
    VAR __Result = IF(HASONEVALUE(Sheet1[Date]), [Final Price in €], SUMX(__Table, [__Value]))
RETURN
    __Result
    • The8's avatar
      The8
      Helper II
      2 years ago

      Hi Greg_Deckler 

      I have gone through your posts and I have also tried DAX with material but I got error even though.

      Modified Measure I used is 

      "
      Net Price Total =
          VAR __Table = SUMMARIZE( 'Sheet1', [Date],[Material], "__Value", [Net Price])
          VAR __Result = IF(HASONEVALUE(Sheet1[Date]), [Net price], SUMX(__Table, [__Value]))
      RETURN
          __Result
      "

      Can you help me regarding this?

      Thanks in advance Greg_Deckler