Forum Discussion

YJ's avatar
YJ
Resolver II
6 years ago

TEXTFilter to work on multiple fields

Hi there,

I have been working on the TEXTFILTER (from MS) and instead of the textbox returning all values when the TEXTBOX is empty, i want it to show the table to be empty till there is a text.

I have been trying to make this work: and got a partial solution from: https://community.powerbi.com/t5/Desktop/Visualisations-blank-until-something-selected-in-a-slicer/td-p/109790

From the suggestion in the above i create a measure:

CUPS_UNI_CHK = if(calculate(distinctcount(TestData[GROUPID]),allselected(TestData[GROUPID]))=1,"Y","N")
and put this as a filter in the visual level filter ( when contain "Y")
With one column

This works when i have only one column: GROUPID ( even this does not work always in the case of "A1", i believe cause of the existence of "A11")

However when i added a 2nd column, for example CODIDIOMA, it works but for some columns like CODCLI it does not work anymore ( see below)

with more then 2 columns

Can anyone explained why it doesn't and how best to resolve this??(pbix file below)

https://drive.google.com/open?id=1couzM85XXfm-bhIgAiEkgbSsi3cR8mU0 

Thanks

Sk

 

2 Replies

  • Icey's avatar
    Icey
    Community Support

    Hi YJ ,


    Is this problem solved?


    If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.


    If not, please let me know.


    Best Regards
    Icey