topic Category status based on sub category in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Category-status-based-on-sub-category/m-p/3535119#M135833 <P>Hi All,<BR />I have a table like below. I need to show the overall status of the category based on the sub- category.&nbsp;<BR />1. If all the sub-categories are completed then Category is completed.<BR />2. If each sub category is having 3 different status, category status should be Risk.<BR />3. If sub categories having same status more than the other status, then category should be the Most status.<BR />For Pen- Risk<BR />Pencil- Completed<BR />Marker- In progress.<BR />TIA.</P><TABLE border="1"><TBODY><TR><TD>Category</TD><TD>Sub-category</TD><TD>Status</TD></TR><TR><TD>Pen</TD><TD>Type 1</TD><TD>Risk</TD></TR><TR><TD>Pen</TD><TD>Type 2</TD><TD>Completed</TD></TR><TR><TD>Pen</TD><TD>Type 3</TD><TD>In-progress</TD></TR><TR><TD>Pencil</TD><TD>Type 5</TD><TD>Completed</TD></TR><TR><TD>Pencil</TD><TD>Type7</TD><TD>Completed</TD></TR><TR><TD>Marker</TD><TD>Type 8</TD><TD>In-progress</TD></TR><TR><TD>Marker</TD><TD>Type15</TD><TD>In-progress</TD></TR><TR><TD>Marker</TD><TD>Type 16</TD><TD>Risk</TD></TR></TBODY></TABLE> Wed, 15 Nov 2023 13:11:27 GMT Prabha45 2023-11-15T13:11:27Z Category status based on sub category https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Category-status-based-on-sub-category/m-p/3535119#M135833 <P>Hi All,<BR />I have a table like below. I need to show the overall status of the category based on the sub- category.&nbsp;<BR />1. If all the sub-categories are completed then Category is completed.<BR />2. If each sub category is having 3 different status, category status should be Risk.<BR />3. If sub categories having same status more than the other status, then category should be the Most status.<BR />For Pen- Risk<BR />Pencil- Completed<BR />Marker- In progress.<BR />TIA.</P><TABLE border="1"><TBODY><TR><TD>Category</TD><TD>Sub-category</TD><TD>Status</TD></TR><TR><TD>Pen</TD><TD>Type 1</TD><TD>Risk</TD></TR><TR><TD>Pen</TD><TD>Type 2</TD><TD>Completed</TD></TR><TR><TD>Pen</TD><TD>Type 3</TD><TD>In-progress</TD></TR><TR><TD>Pencil</TD><TD>Type 5</TD><TD>Completed</TD></TR><TR><TD>Pencil</TD><TD>Type7</TD><TD>Completed</TD></TR><TR><TD>Marker</TD><TD>Type 8</TD><TD>In-progress</TD></TR><TR><TD>Marker</TD><TD>Type15</TD><TD>In-progress</TD></TR><TR><TD>Marker</TD><TD>Type 16</TD><TD>Risk</TD></TR></TBODY></TABLE> Wed, 15 Nov 2023 13:11:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Category-status-based-on-sub-category/m-p/3535119#M135833 Prabha45 2023-11-15T13:11:27Z Re: Category status based on sub category https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Category-status-based-on-sub-category/m-p/3535274#M135847 <P><img /></P> Wed, 15 Nov 2023 14:37:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Category-status-based-on-sub-category/m-p/3535274#M135847 ThxAlot 2023-11-15T14:37:04Z