Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to get a distinct count between two set analysis measures?
In the example below, I want the sum of the measures, where Measure 1 = 1306 and Measure 2 = 162, but there are 6 records that fit the criteria in both sets.
Measure 1: Count({$<CodStatus={'20', '21', '22'}>} Distinct NroProposta)
Measure 2: Count({$<CodStatus={'23', '71'}, DscStatus={'AA', 'AD'}>} Distinct NroProposta)
Ideally I want a Measure 3 that doesn't count those 6 records twice, returning 1462 instead of 1468.
May be this
Count({$<CodStatus={'20', '21', '22'}>+<CodStatus={'23', '71'}, DscStatus={'AA', 'AD'}>} Distinct NroProposta)
May be this
Count({$<CodStatus={'20', '21', '22'}>+<CodStatus={'23', '71'}, DscStatus={'AA', 'AD'}>} Distinct NroProposta)
Perfect, thanks!