Slicer value which filters comma separated data - Matrix Report

PowerBITesting 

Can you try this measure, you select multiple codes as well

measureFilterActivity = 

VAR selectedActivity = ALLSELECTED(Activity[Code]) 
var _sum = 
SUMX(
    VALUES(Accounts[Activity Type]),
    IF(
    COUNTROWS(
        FILTER(
            selectedActivity,
            SEARCH(Activity[Code],Accounts[Activity Type],,0) > 0
        )
    ) >0, CALCULATE(SUM(Accounts[Value]))
    )
)
RETURN

_sum

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn

?

Hi PowerBITesting ,

According to my understanding, you want to calculate the total when the value of Activity Type contains slicer’s selected value, right?

You could use the following formula:

totalMeasure =
VAR _selected =
    SELECTEDVALUE ( 'Activity Type'[ID] )
RETURN
    IF (
        CONTAINSSTRING ( SELECTEDVALUE ( Account[Activity Type] ), _selected ),
        1,
        0
    )

// Apply Conditional formatting

backColor =
VAR _selected =
    SELECTEDVALUE ( 'Activity Type'[ID] )
VAR _selectedColor =
    CALCULATE (
        SELECTEDVALUE ( 'Activity Type'[Color] ),
        FILTER ( ALL ( 'Activity Type' ), 'Activity Type'[ID] = _selected )
    )
RETURN
    IF (
        CONTAINSSTRING ( SELECTEDVALUE ( Account[Activity Type] ), _selected ),
        _selectedColor,
        "White"
    )

My visualization looks like this:

Is the result what you want? If you have any questions, please upload some data samples and expected output.

Please do mask sensitive data before uploading.

Best Regards,

Eyelyn Qin

PowerBITesting , Try like

measureFilterActivity =  
VAR selectedActivity = SELECTEDVALUE('Activity Type'[ID]) 
return  
CALCULATE([measure_Total], 
Filter(All(Account),  Account[Activity Type], selectedActivity
))