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 "Late" 

- Ontime% will be based on overall status.. 

 

 

Need Help
Tips and Tricks

8 Replies

  • 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.