Measure to summarize MIN

[Anonymous]

Hi community, Would be great if anybody can help me with my problem. I'm trying to create a visual based on the table 'Prognoselement':

In a matrix visual I want to have the MIN values from the column Adjust per OwnerId and PeriodId. It should look like this:

With this measare I don't get the MIN, but the sums per period and owner:

Commit FC Adj new =
MINX(
            KEEPFILTERS(VALUES(Prognoseelement[PeriodId]));
            CALCULATE(SUM(Prognoseelement[Adjustment]))
)

Has anybody an idea how to correct this wrong measure?

Thanks in advance!!!

Regards,

Harald

[Anonymous]

that's a overcomplicated MINX

Commit FC Adj new =
MINX(
            Prognoseelement;Prognoseelement[Adjustment]
)

your filter groups by OwnerID and Period will filter your rows and MINX will extract the minimum value in that subset

[Anonymous]

Hi,

Thank you for your quick response. This works exactly for my description.

But would it be possible to change your measure to have the OwnerIds in a slicer and select multiple owners and then get the totals for the minimums of each of them. For a single selection it works, but not for multiple. In the visual there are only PeriodId as rows and Adjust as value. Sorry for not describing this in my 1st post.

Best Regards,

Harald

[Anonymous]

So you want, filtered by A or B the SUM of the MINIMUM value of each PeriodId?

So A would be 500.000 and
B would be 450.000 (for M1) + 750.000 (for M2)?

Otherwise can you explain your expected result?

[Anonymous]

A and B can be selected in a slicer. And these should be the results:

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

We can remove the OwnerId from the column filed and change to use the following measure.

Commit FC Adj new =
SUMX (
    ADDCOLUMNS (
        DISTINCT ( 'Prognoselement'[OwnerId] ),
        "min", CALCULATE ( MINX ( 'Prognoselement', [Adjustment] ) )
    ),
    [min]
)

BTW, pbix as attached.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-lid-msft ,

Thanks a lot for your solution. Works perfectly for me.

Best Regards,

Harald