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
Super 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
      Super 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")