Forum Discussion
Count Based on two columns
Hello, I have a Table, N_Name O_Name O_Status patID A O1 Completed 8652 A O1 Completed 8652 A O1 Completed 8652 A O1 Completed 8718 A O1 Completed 8718 A ...
Hi,
This measure works
Count = coalesce(CALCULATE(DISTINCTCOUNT(Data[patID]),Data[patID]<>blank()),0)Hope this helps.
Why have you used the ALL function there? Try this measure
x_Applications Acted Upon = CALCULATE(DISTINCTCOUNT('Left Join'[LOANS.PAT_ID]), 'Left Join'[Application Status] == "Acted",'Left Join'[LOANS.PAT_ID]<>BLANK())
Thank you so much Sir