Showing values only if exists data on the hierarchy

JoaoMonteiro · June 18, 2021, 4:35pm

Hi all,

I have a Matrix table with 3 levels of hierarchy.
I want any value to be shown, for example at level 3 if I don’t have any items at that level.

I really appreciate your help.
Thanks

Regards,
Joao Monteiro

BrianJ · June 18, 2021, 5:16pm

Based on what you’ve provided, I can only give a pseudocode-ish response, but I think this basic approach should work:

If this doesn’t do the trick, please post a PBIX file and I’d be glad to work through a specific solution with you.

Thanks.

JoaoMonteiro · June 18, 2021, 5:29pm

It works.
Thank you so much.

Regards,
Joao Monteiro