Forum Discussion

srlabhe's avatar
srlabhe
Super User
7 months ago
Solved

Selecting Multiple values in Measure Filter

Hi PBI Gurus

I have below measure created which has o/p as text values

 

varMeasRMAssignDiff =
VAR _StartExists = [varExistsatStart] > 0
VAR _EndExists = [varExistsatEnd] > 0
VAR _StartKey = [varKeyAtStart]
VAR _EndKey = [varKeyAtEnd]
VAR _RMlogin=SELECTEDVALUE(LOGIN_ID)
RETURN

SWITCH (
TRUE(),
--- if RM Login is Empty
ISBLANK(_RMlogin)=TRUE() ,
 "Not Found",

-- Present in both and unchanged
_StartExists && _EndExists && (ISBLANK(_StartExists)=FALSE() && ISBLANK(_EndExists)=FALSE()),
"No changes",

NOT _StartExists && NOT _EndExists,
"No changes",

-- Record added in End Snapshot
NOT _StartExists && _EndExists,
"newly assigned",

-- Record removed from End Snapshot
_StartExists && NOT _EndExists,
"unassigned",

-- Present in both but data changed
_StartExists && _EndExists && _StartKey <> _EndKey,
"Modify",
BLANK()
)
 
Then I have a disconnected table 
ChangeType = DATATABLE("Change", STRING, { {"No risk managers found for the selected desk and legal entity"}, {"No changes"}, {"RM newly assigned"}, {"Modify"},{"RM unassigned"},{"RM could be assigned but is not"} })
 
I have another measure to apply on the table visual
varIsInSelectedChange =
VAR selChange = SELECTEDVALUE( ChangeType[Change] ) // value selected in ChangeType slicer
VAR rowChange = [varMeasRMAssignDiff] // the computed change label for the row
RETURN
IF(
ISBLANK(selChange) || ISBLANK(rowChange),
1, // if no change selected or row has no label, keep it visible
IF(rowChange = selChange, 1, 0)
)
Now when I add varMeasRMAssignDiff as filter in table visual and varIsInSelectedChange =1 ,it allow me to select single value well but when I try to select mutiple values its doesnt work the way it should.
As it keep showing data for other values too.
How to make the meausre as filter to work even for multiple values selections?
 
Need Help
  • srlabhe's avatar
    srlabhe
    7 months ago

    I could achieve this by changing varIsInSelectedChange to below 

    varIsInSelectedChange =
    VAR selectedChanges = VALUES( ChangeType[Change] ) // Get all selected values as a table
    VAR rowChange = [varMeasRMAssignDiff] // the computed change label for the row
    RETURN
    IF(
        ISBLANK( rowChange ),
        1, // if row has no label, keep it visible
        IF(
            ISEMPTY( selectedChanges ),
            1, // if no selection in slicer (slicer is empty), all rows are visible
            IF(
                rowChange IN selectedChanges, // Check if the row's change label is within the selected list
                1,
                0
            )
        )
    )

1 Reply

  • srlabhe's avatar
    srlabhe
    Super User
    7 months ago

    I could achieve this by changing varIsInSelectedChange to below 

    varIsInSelectedChange =
    VAR selectedChanges = VALUES( ChangeType[Change] ) // Get all selected values as a table
    VAR rowChange = [varMeasRMAssignDiff] // the computed change label for the row
    RETURN
    IF(
        ISBLANK( rowChange ),
        1, // if row has no label, keep it visible
        IF(
            ISEMPTY( selectedChanges ),
            1, // if no selection in slicer (slicer is empty), all rows are visible
            IF(
                rowChange IN selectedChanges, // Check if the row's change label is within the selected list
                1,
                0
            )
        )
    )