Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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 

)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

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's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      Greg_Deckler
      Community Champion
      3 years ago

      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

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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 

)