Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a Production Table with Tons and Meters and I have an Asset Table with a Site Column and an Asset Group Type Column. I've got a requirement for a measure to show Tons for certain Asset Group Types and show Meters for other Asset Group Types. I've been able to do a DAX query that does this, but if I try and slice on Site, my values of production (tons and meters) don't slice, they only show the total. There is a relationship between the Production Table and the Asset Table on Site. Here is my DAX query for the calculated measure on my Production table.
Tons/Meters =
IF (
VALUES ( Asset[AssetGroupType] ) IN { "AssetType1", "AssetType2" },
SUM ( Production[Tons] ),
SUM ( Production[Meters] )
)
Production Table:
Site | Tons | Meters |
Site1 | 100 | 5 |
Site2 | 200 | 10 |
Site3 | 300 | 15 |
Asset Table:
Asset | AssetType | Site |
Asset1 | AssetType1 | Site1 |
Asset2 | AssetType2 | Site1 |
Asset3 | AssetType3 | Site1 |
Asset4 | AssetType3 | Site2 |
Asset5 | AssetType1 | Site2 |
Asset6 | AssetType2 | Site3 |
Solved! Go to Solution.
Please try
Tons/Meters =
SUMX (
VALUES ( Asset[AssetGroupType] ),
IF (
Asset[AssetGroupType] IN { "AssetType1", "AssetType2" },
SUM ( Production[Tons] ),
SUM ( Production[Meters] )
)
)
Please try
Tons/Meters =
SUMX (
VALUES ( Asset[AssetGroupType] ),
IF (
Asset[AssetGroupType] IN { "AssetType1", "AssetType2" },
SUM ( Production[Tons] ),
SUM ( Production[Meters] )
)
)
Try wrapping the sum inside the calculate function:
IF (
VALUES ( Asset[AssetGroupType] ) IN { "AssetType1", "AssetType2" },
CALCULATE(SUM ( Production[Tons] )),
CALCULATE(SUM ( Production[Meters] ))
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
69 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
32 | |
28 | |
24 | |
24 |