topic Re: MIN value at category level on already created measure in DAX Commands and Tips

MIN value at category level on already created measure

veeramahesh — Mon, 15 Apr 2024 13:54:22 GMT

Hi Everyone,

Please help to created min value already created measure.

Expected result is green color column.

Thank you,

Veera Mahesh

DataNinja777 — Mon, 15 Apr 2024 14:28:16 GMT

I am assuming that you wanted your output in calculated column because visual will summarize the duplicate values and categories.

Minx = minx(values('Table'[Category]),'Table'[Expected result])

You can produce you required output by writing a dax formula like above.

Best regards,

veeramahesh — Tue, 16 Apr 2024 06:24:12 GMT

Hi DataNinja777, Thank you for your solution but I am expecting as measure and to avoiding summarize, now I have added Index column.

Please find the below screenshot.

Please note, Created Measure is a measure at visaul level and based I need Expected Result is min Values at Category measure.

But I tried measure no luck.

Thanks in advance.

veeramahesh — Tue, 16 Apr 2024 09:07:33 GMT

Thank you,

veeramahesh — Tue, 16 Apr 2024 09:08:32 GMT

Thank you so much @DataNinja777