Forum Discussion

Sander1401's avatar
Sander1401
Helper II
3 years ago
Solved

Help needed with measure

Hi all,   I need help with a simple measure, but I don't get it working... I have a dataset with Producttype - current month and Producttype - last month and numbers. It shows the number of custo...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Sander1401 ,

     

    I can probably understand your idea from the formula you provided, but I don't correspond to your desired result. I don't know what you expect, such as 9.434 is calculated from the sample data.

    For now, you may try this measure

    COUNT - IN =
CALCULATE (
    SUM ( 'Table'[Count] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        [Producttype - current month] = MAX ( 'Table'[Producttype - current month] )
            && [Producttype - current month] <> [Producttype - last month]
    )
)

     

     

    Best Regards,

    Stephen Tao

     

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

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Sander1401 ,

 

I can probably understand your idea from the formula you provided, but I don't correspond to your desired result. I don't know what you expect, such as 9.434 is calculated from the sample data.

For now, you may try this measure

COUNT - IN =
CALCULATE (
    SUM ( 'Table'[Count] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        [Producttype - current month] = MAX ( 'Table'[Producttype - current month] )
            && [Producttype - current month] <> [Producttype - last month]
    )
)

 

 

Best Regards,

Stephen Tao

 

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