General Count / Sum function not working

Hi Anonymous ,

I think you can create some measures by IF function.

AC / FLAG = 
IF ( MAX ( 'MERGE_BillingSUMMARY'[VISIT AGE] ) >= 18, "Adult", "Child" )

Qualifying Units = 
CALCULATE (
    SUM ( MERGE_BillingSUMMARY[Units] ),
    FILTER (
        'MERGE_BillingSUMMARY',
        MERGE_BillingSUMMARY[CPT Code]
            IN {
            "90791",
            "90832",
            "90834",
            "90837",
            "90839",
            "90846",
            "90847",
            "90853",
            "90839"
        }
    )
)

REMAINING UNITS = 
VAR _MAX =
    IF ( MAX ( MERGE_BillingSUMMARY[VISIT AGE] ) >= 18, 12, 24 )
RETURN
    _MAX - [Qualifying Units]

Then build a table visual.

If you want to build a date range slicer, I suggest you to create a DimDate table and then build a relationship between two tables.

DimDate = 
CALENDARAUTO()

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.