Forum Discussion

sorayausher's avatar
sorayausher
New Member
2 years ago

Divide two distinct count values returning 1

Hi,   I am having an issue when I try to create a measure to divide 2 distinct count values. The measure appears to be working in the totals, but when trying to break it down into further categorie...
aduguid's avatar
aduguid
Memorable Member
2 years ago

Try this measure

 

Measure = 
	DIVIDE(
		  CALCULATE(DISTINCTCOUNT('All data_IT'[Data 1.Clnt_Id]), 'All data_IT'[Data 1.Group_tax_outcome] <> "incurred accounting loss")
		, DISTINCTCOUNT('All data_IT'[Data 1.Clnt_Id]
	)

 

 

sorayausher's avatar
sorayausher
New Member
2 years ago

Whilst I am not getting 1  values when I use that measure, the filter doesn't appear to be working, as there are values in the category I attempted to filter out.