Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Hiding nested value within subtotals in Matrix visual

Hi support, 

I'm looking to build a matrix visual with the nested values omitted from a specific column in this case 'Population' so its not repeated throughout list of the cancer types though the values are still required to calcualte '% cancer prevalance' - see Visual 2 

 

Can you assist?

Need Help
Tips and Tricks
  • DataInsights's avatar
    DataInsights
    4 years ago

    Anonymous,

     

    You can use the HASONEVALUE function. Example:

     

    Population =
IF (
    HASONEVALUE ( DimTable[Cancer Type] ),
    BLANK (),
    SUM ( FactTable[Population] )
)

     

1 Reply

  • DataInsights's avatar
    DataInsights
    Icon for Super User rankSuper User
    4 years ago

    Anonymous,

     

    You can use the HASONEVALUE function. Example:

     

    Population =
IF (
    HASONEVALUE ( DimTable[Cancer Type] ),
    BLANK (),
    SUM ( FactTable[Population] )
)