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","90837","90847","90846","G0176","ATIND","MTGRP","MTIND","97110"})
However, when I try to show the Therapies by Procedure code it shows the grand total in each. How do I get the measure to equal the correct number for each Procedure code?
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/
1 Reply
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/