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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Try new column and measure

 

new column
overall Status= countx(filter(Table, [product] = earlier([product] ) && [Status] = "Late"),[product])

New meausre  
divide(calculate(distinctcount(Table[Product]), [overall Status] = "Late"), calculate(distinctcount(Table[Product]) ,all(Table)))

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi amitchandak , 

 

Thanks and appreciate very much on your fast response. 

- I hv tried but it doesnt work as expected. 

 

Overall status column 

- Can help to show the overall status in text format  ? ( Shown in expected output in first post) 

( if there is a "Late" in status column for the product , then will take the worst case as "late", else will be "On time"  ) 

- the overall status dax function you shared is ignoring "On time" status  as below 

- Measure logic is not working. 

 

 

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