Forum Discussion

Bimbone's avatar
Bimbone
Helper I
1 year ago
Solved

Filtering visuals using slicers combinations

(As I am getting no more reply to my previous threads, I will provide here the latest info as a new post)   I have a table called "CoppeCitte" with several columns, you can see below a sample:   ...
Need Help
  • v-menakakota's avatar
    v-menakakota
    1 year ago

    Hi Bimbone ,

    Thank you for reaching out to us on the Microsoft Fabric Community Forum.

    Please post regarding the same in the issues forum for wider visibility:

    Issues - Microsoft Fabric Community

    If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.



     

     

freginier's avatar
freginier
Solution Sage
1 year ago

Hey there,

This happens because the CONTAINSROW function requires all columns of the table expression to be specified.

You need to ensure that all required columns are correctly referenced. Here’s how you can modify the measure:

SelectedSFPairs =
VAR SelectedComp = SELECTEDVALUE(CoppeCitte[Competizione])
VAR SelectedYear = SELECTEDVALUE(CoppeCitte[Anno])
VAR SelectedCity = SELECTEDVALUE(CoppeCitte[CittaMain])

RETURN
IF(
CONTAINSROW(
VALUES(CoppeCitte),
CoppeCitte[Competizione], SelectedComp,
CoppeCitte[Anno], SelectedYear,
CoppeCitte[CittaMain], SelectedCity
), 1, 0
)

 

Then use SelectedSFPairs as a visual filter on the table and set it to 1 so only matching records are displayed.

 

Hope this helps!

😁😁

 

Bimbone's avatar
Bimbone
Helper I
1 year ago

Hi again freginier ,

 

thanks for the suggestion, but I still have some errors, as it says it "Cannot find name [Competizione] and "Cannot find name [Anno]" and "Cannot find name [CittaMain"] , in the bottom part of the code (after the VALUES)