Forum Discussion
Using a Measure to Combine Multiple Columns into one Card
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 ) )
Hi Previsible
Before getting into specifics of the DAX, just checking the logic.
The current ClientCountYesAndNASpecific measure effectively counts rows where this condition is true:
'Deskside QA'[Didtheresourcefollow-upwit] IN {"Yes", "NA"}
|| 'Deskside QA'[Didthetechnicianpracticethe3Stri] IN {"Yes", "NA"}i.e. either of the columns Didtheresourcefollow-upwit or Didthetechnicianpracticethe3Stri is equal to "Yes" or "NA".
But from your screenshot, Didthetechnicianpracticethe3Stri = "NA" on all 165 rows, so this condition is true for all 165 rows.
Is this what you intended?
From your example at the end, the expected result of 149/165 = 90.3% looks to be based on the values in column Didtheresourcefollow-upwit alone.
Regards
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%:
It looks like the discussion has moved to Reddit so I'll let the it continue there.