Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
87 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |