Forum Discussion
Table Total Incorrect with Measure A using in New Measure
Hi,
PBI file attached.
Hope this helps.
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
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 =
The8 Actually the relationship direction needed to be both and not single direction and that was throwing the numbers off. See updated file.
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 ?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"Hi Greg_Deckler
Thanks for your update.
But I still have the save problem with incorrect totals.
Measure I usedNet 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"