Matrix Table low level row

[Umadhandapani]

Hi, the table in the form of matrix table. The low level which that has blank name, how to remove the entire low level row not the high level. If I use blank, the high level also removed.

[ALLUREAN · Accepted solution]

Hi, @Umadhandapani 

Please check this:

https://www.dropbox.com/s/j6qvoxd81iwdpuy/Matrix%20Table%20low%20level%20row%20%28allure-analytics.c...

You need to replace blanks with null in Power Query, then use the measure.

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

https://www.linkedin.com/company/77757292/

[Umadhandapani]

The measure returns both low and high level removed, but I required only the low level to be removed

[VahidDM]

Hi @Umadhandapani 

Click on the ↑ highlighted button in the following image:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/