Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Create custom table according to multiple conditions

Hi Guys, I need to visualize data in a table form based on multiple conditions. I already have a master data table where all values are vaiable . Condition: Only those  Entities must show which w...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous 

Create a calculated column

has purple =
CALCULATE (
    COUNT ( 'Table'[Color] ),
    FILTER (
        ALLEXCEPT (
            'Table',
            'Table'[Entity]
        ),
        'Table'[Year]
            = EARLIER ( 'Table'[Year] ) - 1
            && 'Table'[Color] = "Purple"
    )
)

Then create a measure

only show color = IF(MAX([has purple])<>BLANK(),MAX([Color]))

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.