Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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] ))
)
User | Count |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
86 | |
54 | |
54 | |
38 | |
21 |