Forum Discussion

Matt0515's avatar
Matt0515
Frequent Visitor
6 years ago
Solved

Measure Using "Or" in a table to Count Rows with multiple qualifiers

Hello,   I am struggling to write a DAX Calculation to report the number of records that qualify based on multiple components. I have tried to use the "OR" function several different ways and the ...
Help with DAX Measure
  • deevaker's avatar
    deevaker
    6 years ago

    Try this one :

     

    2020 TMS/WS MKT MQL2 =
    CALCULATE (
        COUNTROWS ( Raw_Data ),
        FILTER (
            ALLSELECTED ( Raw_Data ),
    YEAR ( Raw_Data[Created Date] ) = 2020 &&
    (Raw_Data[Opportunity Solution] = "X" || Raw_Data[Opportunity Solution] = "Y")
    ))
deevaker's avatar
deevaker
Icon for Resolver I rankResolver I
6 years ago

Try this one :

 

2020 TMS/WS MKT MQL2 =
CALCULATE (
    COUNTROWS ( Raw_Data ),
    FILTER (
        ALLSELECTED ( Raw_Data ),
YEAR ( Raw_Data[Created Date] ) = 2020 &&
(Raw_Data[Opportunity Solution] = "X" || Raw_Data[Opportunity Solution] = "Y")
))