Forum Discussion
Solved
Help using CALCULATE and FILTER
Hello I am trying to use a distinct count using CALCULATE and FILTER but for some reason is not working: Measure "$ Net Sales" is = Sales - Return and is working fine, but when I try to count ...
Hmm. That's strange unless [Return] and [Sales] are measures too. (I was assuming they were columns.)
If they are measures, then I'd recommend a different approach:
#C Net = SUMX ( DISTINCT ( 'Venta Neta'[SC_CODIGO] ), IF ( [Return] > [Sales], 1 ) )
Thank you Alexis for your help, now "#C Neto" column is ok, but the total number is counting all rows, it shoud be 669 (which have 1 in #C Neto column) and not 749.
Regards
Hmm. That's strange unless [Return] and [Sales] are measures too. (I was assuming they were columns.)
If they are measures, then I'd recommend a different approach:
#C Net =
SUMX (
DISTINCT ( 'Venta Neta'[SC_CODIGO] ),
IF ( [Return] > [Sales], 1 )
)Thank you very much for your help! now is working!
Regards