Forum Discussion
Solved
Calculate Distinct values
Hi there, Just wondering if someone can help with the below: I want to calculate distinct value for my measure Serious Incident Total = CALCULATE( [Total Incidents] - [Total Not Ser...
This should get you the result you wanted- worked for my test:
Serious Incident Total = VAR _Incidents = CALCULATETABLE( DISTINCT( Forms[itrak_formid] ), Forms[Form Type] = "Incident & Investigation" ) VAR _NotSerious = CALCULATETABLE( DISTINCT( Forms[itrak_formid] ), Forms[Category] = "Not Serious" ) RETURN COUNTROWS( EXCEPT( _Incidents, _NotSerious ) )We create a table of distinct incidents (_Incidents), a table of distinct not serious forms (_NotSerious),
Remove IDs that appear in _NotSerious from _Incidents,
And count the rows on the resulting table.
chavanr , if want distinct values a measure first you need to get a grouping for that
like
measure =
var _tab = summarize(Forms,Forms[Column], "_1",[Total Incidents ])
return
countx(values(_tab[_1],[_1])
measure =
var _tab = summarize(Forms,Forms[Column], "_1",[Total Incidents ])
return
countx(summarize(_tab, _tab[_1],[_1])