IN statement Dimnesion problems

[Anonymous]

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?

[amitchandak · Accepted solution]

@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/