Forum Discussion
IN statement Dimnesion problems
Hello, I have a measure that sums Quantity if the Procedure code is one of the codes below. Therapies = CALCULATE(SUM(ARCharges[QUANTITY]),ARCharges[PROCEDURE CODE] IN {"90853", "90832","90834","908...
Anonymous , Try like
Therapies = CALCULATE(SUM(ARCharges[QUANTITY]),filter(ARCharges,ARCharges[PROCEDURE CODE] IN {"90853", "90832","90834","90837","90847","90846","G0176","ATIND","MTGRP","MTIND","97110"}))
if this workout, refer why
http://dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/
Anonymous , Try like
Therapies = CALCULATE(SUM(ARCharges[QUANTITY]),filter(ARCharges,ARCharges[PROCEDURE CODE] IN {"90853", "90832","90834","90837","90847","90846","G0176","ATIND","MTGRP","MTIND","97110"}))
if this workout, refer why
http://dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/