Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculation based on customized filter

Hi,   I have dataset like, VIN NO Category Status ABC1 Axile PASS ABC1 Cabin PASS ABC1 Engine FAIL DEF2 Axile FAIL DEF2 Cabin PASS DEF2 Engine FAIL GHI3 Axil...
General Comment
Need Help
Tutorial Requests
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous 

    Thank you for your feedback.

    Please check the below picture and the link down below.

     

     

    Top2 defect category =
    CONCATENATEX (
    TOPN ( 2, VALUES ( Data[Category] ), [Count Fail], DESC ),
    Data[Category],
    ", ",
    [Count Fail], DESC
    )
     
     

    Hi, My name is Jihwan Kim.


    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Jihwan,

 

For the First Question i got answer from you (Pass Count)

But for 2nd Question,

My Actual requirement is 

2. Top 2 defect category name with respect to count of Defect category ,Filter is Name of category with filter Fail needs to apply in DAX.

 

Example for above scenario - 

Top  2 Defect is,

Axile

Engine

 

Thanks,

Mohan

 

 

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

Hi, Anonymous 

Thank you for your feedback.

Please check the below picture and the link down below.

 

 

Top2 defect category =
CONCATENATEX (
TOPN ( 2, VALUES ( Data[Category] ), [Count Fail], DESC ),
Data[Category],
", ",
[Count Fail], DESC
)
 
 

Hi, My name is Jihwan Kim.


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi,

     

    Thanks a lot.

    Now working fine.

     

    Thanks,

    Mohanraj