Forum Discussion

Anonymous's avatar
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 v...
Need Help
  • V-lianl-msft's avatar
    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.

parry2k's avatar
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's avatar
    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,