Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Define output with condition when same row name with different output

Hi All ,    Can pls guide me how do i get the expected output as below ?  - i have same value under Product column with different status ,if there is "Late" in status , then we will categories as ...
Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI Ashish_Mathur , 

Thank you for the file., it is working ! 

 

Could you please help me to interpret this measure that you created  ? 

Not too sure how this only consider worst case "late" when both "On time" and "late" condition exists. 

 

Measure = if(ISNUMBER(CALCULATE([Countrow_],FILTER(VALUES(Data[Product]),[Countrow_]=[On time count]))),"On Time","Late")
 
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

You are welcome.

If the number of rows of that product equal the number of on time entries of that product, then show On time, else show late.

If my previous reply helped, please mark that as Answer. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Ashish_Mathur  , 

    Got it , thank you very much for the explanation. 

     

    I tried to combine ur dax solution with my other calculation( daydiff_item) ..result was odd, can please help shed some light ? 

     

    Category_Product =

    Var Daycheck = If(ISBLANK('Table1'[DayDiff_Item]),Blank() ,
    if('Table1'[DayDiff_Item] <= 1 , "On Time" ,
    If('Table1'[DayDiff_Item] >= 2 , " Late " ,
    Check data
    )))

    Var Ontime2 = CALCULATE(countallrow, FILTER('Table1', Daycheck = "On Time"))
    Return

    if(ISBLANK('Table1'[DayDiff_Item]),Blank(),
    If(ISNUMBER
    (CALCULATE([CountROW_all_row],FILTER(VALUES('Table1'[Product ]),
    CountROW_all_row= Ontime2))),"On Time","Late"))

     

     

    the output  : All status in "Late" 

     

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      5 years ago

      Hi,

      I am not sure what you are trying to accomplish there.  If you still need my help, share some data and explain the question in simple English rather than pasing your formula.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Ashish_Mathur  , 

         

        So sorry for that ! 

        I found my mistake after some online research.. 

         

        Thanks again for your help ,  learnt something new 🙂