Forum Discussion

Previsible's avatar
Previsible
Regular Visitor
1 year ago
Solved

Using a Measure to Combine Multiple Columns into one Card

Hello there,   I am attempting to build a dashboard that would require me to combine multiple columns of data to provide more detailed breakdowns of each section.  Each column has only 3 expecte...
  • Previsible's avatar
    Previsible
    1 year ago

    For anyone who comes across this post seeking the answer, it was provided by a reddit user.

     

    Instead of the OR Statement in my DAX || I needed to use an AND statement &&

    IE:

    ClientTotalSpecificResponses = 
    SUMX(
        'Deskside QA',
        IF(
            NOT(ISBLANK('Deskside QA'[Didtheresourcefollow-upwit])) &&
            NOT(ISBLANK('Deskside QA'[Didthetechnicianpracticethe3Stri])),
            1,
            0
        )
    )
Previsible's avatar
Previsible
Regular Visitor
1 year ago

For anyone who comes across this post seeking the answer, it was provided by a reddit user.

 

Instead of the OR Statement in my DAX || I needed to use an AND statement &&

IE:

ClientTotalSpecificResponses = 
    SUMX(
        'Deskside QA',
        IF(
            NOT(ISBLANK('Deskside QA'[Didtheresourcefollow-upwit])) &&
            NOT(ISBLANK('Deskside QA'[Didthetechnicianpracticethe3Stri])),
            1,
            0
        )
    )