Forum Discussion

olimilo's avatar
olimilo
Icon for Post Prodigy rankPost Prodigy
6 months ago
Solved

How to exclude blanks from decomposition tree?

The data for this chart is in tabular (pivoted) layout. For the Non-manufacturing and Services categories, the subcategories will always be blank. Is there a way to keep the (Blank) category from dis...
Need Help
  • cengizhanarslan's avatar
    cengizhanarslan
    6 months ago

    Could you try the measure below?

    Tree Count =
VAR _activity =
    SELECTEDVALUE ( 'Table'[Facility Activities] )
RETURN
    IF (
        ISINSCOPE ( 'Table'[Produce] )
            && _activity <> "Manufacturing",
        BLANK(),
        DISTINCTCOUNT ( 'Table'[ID] )
    )
Anonymous's avatar
Anonymous
Not applicable
6 months ago

Hi olimilo,

 

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to cengizhanarslan and MohdZaid_  for prompt and helpful responses.

Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

 

Best regards,
Prasanna Kumar