Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Min for Multiple category

Hi Team,

DAX : I need to find min value for below table in each UID value.

UID, Cat remaining fields are measures (calculated New Measures)

Analysis result_1 : expected UID wise min value
Analysis result_2: UID sum for all min value

Thanks,

KV's

V-lianl-msft
5 years ago
Hi Anonymous ,

Please try to create measures like below:
Min_ = MINX(ALLEXCEPT('Table','Table'[UID]),[Prod_stock]) sum_ = SUMX(ALL('Table'[UID],'Table'[Cat]),[Min_])

Sample .pbix

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

parry2k
Super User
5 years ago
Anonymous min value of which measure, try this

New Measure = SUMX ( SUMMARIZE ( Table, Table[UID], "@MinValue", [Your Measure] ), [@MinValue] )

Check my latest blog post Compare Budgeted Scenarios vs. Actuals to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
- Anonymous
  Not applicable
  5 years ago
  Hi parry2k ,
  
  Min value Not clear, below column "Min" expected UID 44.OIU is 2 and 67 is 4, but showing 3 also.
  it should be 2 for 44.OIU series.
  
  Thanks,
V-lianl-msft
Community Support
5 years ago
Hi Anonymous ,

Please try to create measures like below:
Min_ = MINX(ALLEXCEPT('Table','Table'[UID]),[Prod_stock]) sum_ = SUMX(ALL('Table'[UID],'Table'[Cat]),[Min_])

Sample .pbix

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.