Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Smartsheet Multi-Select > PowerBI Desktop

Hi -    I am looking for some help calculating the number of times each of my departments is tagged in an audit findings.  We are managing our audits in Smartsheet which has a multi-select dropdown...
Need Help
v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

Hi, Anonymous 

Please try formula like:

RESULT =
CALCULATE (
    COUNTROWS ( Table1 ),
    CONTAINSSTRING ( Table1[Department], MAX ( Table2[Department Name] ) )
)

Best Regards,
Community Support Team _ Eason