Forum Discussion

RRaj_293's avatar
RRaj_293
Icon for Helper III rankHelper III
3 years ago
Solved

Dax Help - Min and Max

Hi ,    Scenario- I have a Line Table (A in below pic) which has different orders and their lines for which certain number of days field is calculated. It has negative and positive numbers. The var...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • parry2k's avatar
    parry2k
    3 years ago

    RRaj_293 try this measure: but you have to turn on show items with no data because when you are returning BLANK () where the

    No of Days Measure = 
VAR __MaxDays = MAXX ( Orders, [No of Days] )
VAR __MinDays = MINX ( Orders, [No of Days] )
VAR __CountBlank = COUNTROWS ( FILTER ( Orders, ISBLANK ( [No of Days] ) ) )
RETURN
IF ( __CountBlank >= 1, BLANK (), IF ( __MinDays < 0, __MinDays, __MaxDays ) )

     

    Tweak the above measure as you see fit, as I didn't understand the full logic.

     

     

    order has a blank number of days by default any visual will suppress that rows:

     

     

RRaj_293's avatar
RRaj_293
Icon for Helper III rankHelper III
3 years ago

Hi lbendlin  , Thanks for responding. Yes I got the same using If condition , but the challenge is with the blanks. I have modified the data in the table and the expected reuslts. If there is a combination of +ve , -ve and blank within an order then I need blank displayed at the order level as we are reporting the worst case scanerios . A blank indicates the order is not yet despatched likein order example PQR. If the order has only +ve and -ve's then display the min(farthest) negative number as that indiactes the most number of days taken(worst case scenario) like in example order XYZ.

 

Note - Table data edited for these scenarios in my original post.