Forum Discussion

mohammedferoz12's avatar
mohammedferoz12
Regular Visitor
2 years ago

Need Help with ISFILTERED multiple selections

in Matrix Visual if ISFILTERED has single selection in matrix visual then it gets right value in SELECTEDVALUE mesure,

But when we select multiple or if parent is selected in matrix visual then multiple cells will be selected (Parent & its children) and it gives blank in SELECTEDVALUE measure. Can you help with this scenerio, even if we select multiple only the first one will be displayed in SELECTEDVALUE mesaure. or if the parent is selected then it gives only that specific parent value in SELECTEDVALUE mesasure instead of blank.

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    mohammedferoz12 ,

    Is filter =  calculate(isfiltered(Table), allselected())

    or

    Is filter =  calculate(isfiltered(Table[Column]), allselected())

     

    Now create a measure

    if([Is filter] , concatenatex(Values(Table[Column]), [Column], ", ") )

  • mohammedferoz12's avatar
    mohammedferoz12
    Regular Visitor
    2 years ago

    let me rephrase my issue.

    I am using a parent child hirerchy in a matrix visual. A parent has multiple children.

    Consider a table as item_code, Item_name & item_description.

    in the Matrix visual hirerchy we can just see the item names. When we click any item we have to see the item_code in the card.
    When i select one item i can get the item_code in the card
    but when i click the parent item the entire parent child records are being selected and we get a blank in the card. Instead can we have something like this...
    1) When we click the parent only the parent id will be displayed in the card, it should not consider the selection of other records... OR
    2) we can say if we select multiple records only the first record id should be displayed. how can we achive this ? Kindly suggest.

    I used the below measure :  

    Id = IF(ISFILTERED(‘item_table'), SELECTEDVALUE('CUSTOM VIEW'[item_ID]), "PLEASE SELECT ITEM")