Forum Discussion
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...
Hi,
PBI file attached.
Hope this helps.
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 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"