JsummersHelper I2 years agoSolvedDistinct Count Help Hi, hoping someone can help, I think it is probably pretty simple, but with my lack of knowledge, I am just banging my head against a brick wall! I have a table, one column is an assessment ID, ther...Show MoreDangar3322 years agoHi, Jsummers Try belowAudits with NCs = CALCULATE(DISTINCTCOUNT('SQL Ad Hoc'[AssessmentID]),'SQL Ad Hoc'[NCs?]=1))
Dangar3322 years agoHi, Jsummers Try belowAudits with NCs = CALCULATE(DISTINCTCOUNT('SQL Ad Hoc'[AssessmentID]),'SQL Ad Hoc'[NCs?]=1))
Dangar3322 years agoHi, Jsummers Try belowAudits with NCs = CALCULATE(DISTINCTCOUNT('SQL Ad Hoc'[AssessmentID]),'SQL Ad Hoc'[NCs?]=1))
Dangar332Resident Rockstar2 years agoHi, Jsummers Try belowAudits with NCs = CALCULATE(DISTINCTCOUNT('SQL Ad Hoc'[AssessmentID]),'SQL Ad Hoc'[NCs?]=1))
JsummersHelper I to Dangar3322 years agoDangar332 this appears to have worked, I will double check the results & then accept as the solution, many thanks
Related contentcount distinctDistinct CountDistinct countDAX Calculation for Distinct CountAverage - Distinct Count
