Forum Discussion

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

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

Regular Visitor

1 year ago

That is what I intended. The Column Didthetechnicianpracticethe3Stri is supposed to have all answers NA, this is a new metric to this report and all historical entries received a "pass" by being marked as NA. The hope would be however that ClientPercentage pulls information from both columns as opposed to the one alone.

In testing your theory that it is only pulling the data from one list I added some "NA" and "Yes" data to the SharePoint list and it still shows 100%: