Sum of Minimum Count By YearMonth and Product

[Venkat_s]

Team,

I am struggling to get Minimum value (SUM) by the group.

Here is the Data:

Desired output :

1) When the user selects Start Year & Month (for Active) it should show 200 (Sum of Minimum value on D Year & Month) irrespective of Product.

2) When the user selects Start Year & Month (for Active) and Product then it should show 200 (minimum value).

Thanks,

Regards,

Venkat

[amitchandak]

@Venkat_s , Not very clear

Try a measure like

sumx(summarize(filter(table, table[status] ="Active"),table[Product],"_1", max(Table[count])),[_1])

[Venkat_s]

I mean, If the user selects Start Year&Month The the Minimum Count (Sum of ) value should be on D month and Product Level (By Month and Year) irrespective of Product.

If the user selects Start Year & Month and Product Then the Minimum count (Sum of) should be shown on Product Level.

Start Year & Month are in Slicer.

Keeping Status (Picking only Active) in Graph Filters.

Thanks! 

[Icey · Accepted solution]

Hi @Venkat_s ,

Please check if this is what you want:

Measure =
IF (
    ISFILTERED ( 'Table'[Product] ),
    CALCULATE (
        MIN ( 'Table'[Count] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[D Year&Month] = MAX ( 'Table'[D Year&Month] )
                && 'Table'[Product] = MAX ( 'Table'[Product] )
        )
    ),
    CALCULATE (
        MIN ( 'Table'[Count] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[D Year&Month] = MAX ( 'Table'[D Year&Month] )
        )
    )
)

BTW, .pbix file attached.

Best regards

Icey

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

[Venkat_s]

Hi Amit,

Thanks for your quick response.

I tried this but it doesn't give required output.

for your reference, I am keeping Status as a filter, Start Month Year, Product in Slicer.

When the user selects particular start Year& Month by default the minimum (SUM of ) value should be shown on D Month & year Irrespective of Product Until the user selects Product.

Thanks!