Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
HI,
I have a table
The condition :
Sklad = sklad1
Specification = Specification1
Document type = Material
Sklad = sklad2
Specification = Specification3
Document type = Material
Sklad = sklad3
Document type = Product and Servise
The result should be
| Sklad | Amount |
| Sklad1 | 4000 |
| Sklad2 | 600 |
| Sklad3 | 12780 |
File exempl
Тhanks
Solved! Go to Solution.
@DimaMD
I modified your Amount1 measure:
Amount1 =
VAR __SKLAD = SELECTEDVALUE(Sklad[Sklad])
RETURN
SWITCH(
TRUE(),
__SKLAD = "sklad1" , CALCULATE( SUM('Table'[Amount]), 'Table'[Specification] = "Specification1",'Table'[Document type] = "Material"),
__SKLAD = "sklad2" , CALCULATE( SUM('Table'[Amount]), 'Table'[Specification] = "Specification2",'Table'[Document type] IN {"Product","Services"}),
__SKLAD = "sklad3" , CALCULATE( SUM('Table'[Amount]), 'Table'[Document type] IN {"Product","Services"})
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@DimaMD
I modified your Amount1 measure:
Amount1 =
VAR __SKLAD = SELECTEDVALUE(Sklad[Sklad])
RETURN
SWITCH(
TRUE(),
__SKLAD = "sklad1" , CALCULATE( SUM('Table'[Amount]), 'Table'[Specification] = "Specification1",'Table'[Document type] = "Material"),
__SKLAD = "sklad2" , CALCULATE( SUM('Table'[Amount]), 'Table'[Specification] = "Specification2",'Table'[Document type] IN {"Product","Services"}),
__SKLAD = "sklad3" , CALCULATE( SUM('Table'[Amount]), 'Table'[Document type] IN {"Product","Services"})
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Fowmy
thanks for the help
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 20 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 33 | |
| 31 | |
| 19 | |
| 12 | |
| 11 |