create a calculated measure or column based on different conditions

Hi ljx0648 ，

I create a table as you mentioned.

Then I create a calculated column and here is the DAX code.

Column = 
SWITCH (
    TRUE (),
    'Table'[Type] = "Weekly"
        && 'Table'[Frequency] = 1,
        'Table'[Amount] * 'Table'[Count of Plan Purchased] * 4,
    'Table'[Type] = "Weekly"
        && 'Table'[Frequency] = 2,
        'Table'[Amount] * 'Table'[Count of Plan Purchased] * 2,
    'Table'[Type] = "Monthly"
        && 'Table'[Frequency] = 1,
        'Table'[Amount] * 'Table'[Count of Plan Purchased] * 1,
    'Table'[Type] = "Monthly"
        && 'Table'[Frequency] > 1,
        'Table'[Amount] * 'Table'[Count of Plan Purchased] / 'Table'[Frequency],
    BLANK ()
)

Finally you will get what you want.

Best Regards

Yilong Zhou

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