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.
That does not give me what i requested for in my previuos message.
Here are details you requested.
Hello Ashish_Mathur ,
Sheet 1:
| Material | Date | Quantity | Price | Currency |
| X1 | 01.01.2024 | 30 | 86 | EUR |
| X2 | 01.01.2024 | 20 | 177 | USD |
| X3 | 01.01.2024 | 15 | 36 | EUR |
| X1 | 01.02.2024 | 43 | 81 | EUR |
| X2 | 01.02.2024 | 46 | 165 | USD |
| X3 | 01.02.2024 | 34 | 40 | EUR |
| X1 | 01.03.2024 | 28 | 85 | EUR |
| X2 | 01.03.2024 | 46 | 175 | USD |
| X3 | 01.03.2024 | 32 | 35 | EUR |
Sheet 2 :
| From € to $ (Conv. Rate) | Currency |
| 1,08 | USD |
| 1 | EUR |
Both this tables are in relationship by column Currency.
Measures:
1.Final Price in € = DIVIDE(SUM(Sheet1[Price]),SUM('Sheet2'[From € to $ (Conv. Rate)]),0)
2.Net price = DIVIDE([Final Price in €],SUM(Sheet1[Quantity]),0)
3.
"Net Price Total Date Material =
"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
"
Below is the link to acces the file:
https://drive.google.com/file/d/1tanNNwqShDfjB4L7AID--7MuPl52GBny/view?usp=drive_link
I am expecting right totals as highlighted below.
"
Below is the link to acces the file:
https://drive.google.com/file/d/1tanNNwqShDfjB4L7AID--7MuPl52GBny/view?usp=drive_link
I am expecting right totals as highlighted below.
Thanks !
Access Denied message.
Hi Ashish_Mathur ,
I have updated the link.
https://drive.google.com/file/d/1tanNNwqShDfjB4L7AID--7MuPl52GBny/view?usp=sharingHi,
PBI file attached.
Hope this helps.