Forum Discussion
Distinct Count with Filter
Hi Everyone, I am trying to calculate distinct count with filters. I have used the formula: SoldOC = CALCULATE(DISTINCTCOUNT('Dimension - DMA Configs'[Order Code]),FILTER('Measures - Revenue','Me...
Hi tulasik ,
Is the 'Measures - Revenue'[Revenue Total] a measure? We must analyze the formula of this measure if we want to find the error.
The easiest way is to change this measure to the calculated column in 'Dimension - DMA Configs’ table.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.