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:

     

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
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

    Thanks parry2k  . I tried this and logically looks right to me as well but not sure why the records are all blank. I have enabled 'show items with No data'.  If I remove the blank count and just do Min , Max it works except for blank scenarios.

     

    if((SELECTEDVALUE('Line'[NoOfDays]))<=0, Min('Line'[NoOfDays]), MAX('Line'[NoOfDays])),