Hi BI Experts, Need help here to get solution of "Rank based on Serial No, Cycle Count & Fault Type" & "Rank based on serial No, Log Date and Fault Type". With calculated column(DAX) or Power Query is fine. Rank based on Serial No, Cycle Count & Fault Type = Count of distinct Cycles when similar fault Type OccurRank based on serial No, Log Date and Fault Type = Count of distinct last different log Date when similar fault type logged Fault TypeSerial NoCycle CountLog DateRank based on Serial No, Cycle Count & Fault TypeRank based on Serial No, Log Date & Fault TypeBentS1256210-Aug-2111Ink FailureS1256410-Sep-2111Self StrippingS1256831-Dec-2111BentS1256831-Dec-2122Ink FailureS12561023-Feb-2222BentS12561023-Feb-2233Broken WeldS12561023-Feb-2211Self StrippingS12561023-Feb-2222Broken WeldS12561026-Feb-2212Ink FailureS12561026-Feb-2223Self StrippingS12561026-Feb-2223BentS12561026-Feb-2234Not PaintedS12561026-Feb-2211Ink FailureS12561026-Feb-2223BentS12561320-Apr-2245Require StrippingS12561325-Apr-2211Not PaintedS12561325-Apr-2222Ink FailureM083117-Jan-2211Ink FailureM083117-Jan-2211BentM083117-Jan-2211BentM083117-Jan-2211Not PaintedM083117-Jan-2211Not PaintedM083117-Jan-2211Ink FailureM08333-Mar-2222Ink FailureA863111-Oct-2111Broken WeldA863111-Oct-2111Self StrippingA863111-Oct-2111Ink FailureA863114-Oct-2112BentA863114-Oct-2111Ink FailureA863114-Oct-2112 Appriciate for quick solutions Thanks,Dharani

Hi Anonymous ， Please try this code: Rank based on Serial No, Cycle Count & Fault Type = RANKX ( FILTER ( 'Table', [Fault Type] = EARLIER ( 'Table'[Fault Type] ) && [Serial No] = EARLIER ( 'Table'[Serial No] ) ), [Cycle Count], , ASC, DENSE ) Rank based on Serial No, Log Date & Fault Type = RANKX ( FILTER ( 'Table', [Fault Type] = EARLIER ( 'Table'[Fault Type] ) && [Serial No] = EARLIER ( 'Table'[Serial No] ) ), [Log Date], , ASC, DENSE ) Pbix in the end you can refer. Best Regards Community Support Team _ chenwu zhu If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Rank based on three different columns | Microsoft Fabric Community

Forum Discussion

Related content