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

Hi Greg_Deckler 

Thank you, Good day!

You are exactly right, when we change relationship direction to "both" and adding Material into my measure as below is working absolutely fine even with Material Slicer.

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

 

But when I make slicer selection based on date again I have same problem, totals being wrong as below image for your reference.

With Date SLicer Selection:


Any changes needs to be done still ?









Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

The8 That would be:

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

    Hi Greg_Deckler 

    Thanks for your update.

    But I still have the save problem with incorrect totals.


    Measure I used 

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