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

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
Super 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 🙂