Forum Discussion
DAX Measure Error
Hi Experts
I am using teh following measure in a card visula and cannot workout whats wrong with the following measure, it should stright forward either return VAR _ A if teh condition is met or VAR _B
Sample Data (based on the below the expected end result should be 5)
| Count | Worktype | Status | MEUCOMPLIANCEIMPACT |
| 1 | RW | PPM | 0 |
| 1 | RW | PPM | 0 |
| 1 | RW | PPM | 0 |
| 1 | REMST | PPM | 0 |
| 1 | REMST | PPM | 0 |
| 1 | REMST | PPM | 0 |
| 1 | REMST | PPM | 0 |
| 1 | REMST | PPM | 0 |
Remedial Tasks =
VAR _A = CALCULATE([Count],
FILTER(USVF_WO_22_12_22,USVF_WO_22_12_22[WORKTYPE] = "RW" && USVF_WO_22_12_22[MEUCOMPLIANCEIMPACT] = 1),
USVF_WO_22_12_22[STATUS] <> "CAN",
ALL(DimDate[Date]))+0
VAR _B = CALCULATE([Count],
FILTER(USVF_WO_22_12_22,USVF_WO_22_12_22[WORKTYPE] = "REMST" && USVF_WO_22_12_22[MEUCOMPLIANCEIMPACT] = 0),
USVF_WO_22_12_22[STATUS] <> "CAN",
ALL(DimDate[Date]))+0
RETURN
SWITCH( TRUE(),
SELECTEDVALUE(USVF_WO_22_12_22[WORKTYPE] )= "RW" && SELECTEDVALUE(USVF_WO_22_12_22[MEUCOMPLIANCEIMPACT] )= 1 , _A,
SELECTEDVALUE(USVF_WO_22_12_22[WORKTYPE] )= "REMST" && SELECTEDVALUE(USVF_WO_22_12_22[MEUCOMPLIANCEIMPACT]) = 0 , _B
)
Solution
Remedial Tasks = VAR _A = CALCULATE([Count], FILTER(USVF_WO_22_12_22,USVF_WO_22_12_22[WORKTYPE] = "RW" && USVF_WO_22_12_22[MEUCOMPLIANCEIMPACT] = 1), USVF_WO_22_12_22[STATUS] <> "CAN", ALL(DimDate[Date]))+0 VAR _B = CALCULATE([Count], FILTER(USVF_WO_22_12_22,USVF_WO_22_12_22[WORKTYPE] = "REMST" && USVF_WO_22_12_22[MEUCOMPLIANCEIMPACT] = 0), USVF_WO_22_12_22[STATUS] <> "CAN", ALL(DimDate[Date]))+0 RETURN IF( SELECTEDVALUE(USVF_WO_22_12_22[WORKTYPE] )= "RW" && SELECTEDVALUE(USVF_WO_22_12_22[MEUCOMPLIANCEIMPACT] )= 1 , _A , _B )
4 Replies
- Greg_Deckler
Community Champion
Anonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.- Greg_Deckler
Anonymous I did it like this. See attached PBIX below signature.
Remedial Tasks = VAR _A = SUMX( FILTER( USVF_WO_22_12_22, [WORKTYPE] = "RW" && [MEUCOMPLIANCEIMPACT] = 1 && [STATUS] <> "CAN" ), [Count] ) + 0 VAR _B = SUMX( FILTER( USVF_WO_22_12_22, [WORKTYPE] = "REMST" && [MEUCOMPLIANCEIMPACT] = 0 && [STATUS] <> "CAN" ), [Count] ) + 0 VAR __Result = SWITCH( TRUE(), SELECTEDVALUE(USVF_WO_22_12_22[WORKTYPE]) = "RW" && SELECTEDVALUE(USVF_WO_22_12_22[MEUCOMPLIANCEIMPACT]) = 1 , _A, SELECTEDVALUE(USVF_WO_22_12_22[WORKTYPE]) = "REMST" && SELECTEDVALUE(USVF_WO_22_12_22[MEUCOMPLIANCEIMPACT]) = 0 , _B ) RETURN __Result
Solution
Remedial Tasks = VAR _A = CALCULATE([Count], FILTER(USVF_WO_22_12_22,USVF_WO_22_12_22[WORKTYPE] = "RW" && USVF_WO_22_12_22[MEUCOMPLIANCEIMPACT] = 1), USVF_WO_22_12_22[STATUS] <> "CAN", ALL(DimDate[Date]))+0 VAR _B = CALCULATE([Count], FILTER(USVF_WO_22_12_22,USVF_WO_22_12_22[WORKTYPE] = "REMST" && USVF_WO_22_12_22[MEUCOMPLIANCEIMPACT] = 0), USVF_WO_22_12_22[STATUS] <> "CAN", ALL(DimDate[Date]))+0 RETURN IF( SELECTEDVALUE(USVF_WO_22_12_22[WORKTYPE] )= "RW" && SELECTEDVALUE(USVF_WO_22_12_22[MEUCOMPLIANCEIMPACT] )= 1 , _A , _B )
