DAX Measure Error

[Anonymous]

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 

)  

[Greg_Deckler]

@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.

[Anonymous · Accepted solution]

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 

) 

[Anonymous]

Hi Greg... I have posted sample data and expected end result but cannot send link to file. as its difficult. been struggle with this for the whole day

[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