Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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
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
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?
A and B can be selected in a slicer. And these should be the results:
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |