Forum Discussion
Display minimum value on every row under group
Since making this calculation off the measures I already have doesn't work, I decided to create a new table in my DB then create calculated columns to get the answers I needed. Not ideal, but it works.
Thanks everyone for your input.
You probably need to create a new measure and use VAR along with SUMMARIZE or ADDCOLUMN to create a temp table that is essentially the table you show below but as a VAR. Then you can use MINX to grab the minimum of that and return it. You'll probably need an ALL statement in there to remove row context.
See my article here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
Thanks for the reponse.
I did try using SUMMARIZE to create a new table then calculate based off that, which did not work. Below is the code and result. Let me know if you see anything I missed. Thanks.
MINX(
SUMMARIZE(SALES_OrderSize,
PROD__Master_StyleColor[_sc DESC],
INVEN_Stock[Size],
"tmp",
DIVIDE(
SUM(SALES_OrderSize[NetOrdUnits]),
CALCULATE(
SUM(SALES_OrderSize[NetOrdUnits]),
ALLEXCEPT(SALES_OrderSize,
PROD__Master_StyleColor[_sc DESC],
INVEN_Warehouse[WHSE_CD],
PROD_Attributes[Active Sizes],
DATE_OrderEntry[Year],
CUST__Master[Cust Channel],
SALES_OrderHeader[OR_CODE],
CUST__Master[Customer],
PROD__Master_StyleColor[_key_sc]
)
)
,0
)
), [tmp]
)