Forum Discussion

jimpatel's avatar
jimpatel
Icon for Post Patron rankPost Patron
3 years ago
Solved

DAX formula

Hi   Thanks for looking at my post.   I am using below DAX code what should i do please to get information from same table and from same column please. That is i have attached an example "Modifie...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi jimpatel , 

    I have created a simple sample, please refer to it to see if it helps you.

    Create a measure.

     

    _1=CALCULATE(MAX('Table'[status]),FILTER(ALL('Table'),'Table'[material]=SELECTEDVALUE('Table'[material])))

     

    If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information .

     

    Best Regards

    Community Support Team _ Polly

     

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi jimpatel , 

I have created a simple sample, please refer to it to see if it helps you.

Create a measure.

 

_1=CALCULATE(MAX('Table'[status]),FILTER(ALL('Table'),'Table'[material]=SELECTEDVALUE('Table'[material])))

 

If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information .

 

Best Regards

Community Support Team _ Polly

 

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

  • jimpatel's avatar
    jimpatel
    Icon for Post Patron rankPost Patron
    3 years ago

    This is what exatly i am looking for.

     

    Thanks a lot for your time and input 

     

    Jim