Table must be blank

[Anonymous]

I have a very simple table where I need to be in blank before using 2 text filters. is there a simple way to do it?

IMAGEN 1IMAGEN 2 DESIRED RESULT

[edhans · Accepted solution]

Yes @Anonymous but I don't think you can do it by putting the fields themselves into the table. You will need to replace those fields with measures. It gets this result:

The measure for field 1 is this:

Field1 Measure =
IF(
    ISBLANK(
        SELECTEDVALUE(
            Blanks[Field2],
            BLANK()
        )
    ),
    BLANK(),
    SELECTEDVALUE(
        Blanks[Field1],
        BLANK()
    )
)

Basically that is saying, if the selected value of field 2 is a single field, then see if field 1 is also single and show it, otherwise return blank.

Field 2 is identtical with teh field names swapped out as below:

Field1 Measure =
IF(
    ISBLANK(
        SELECTEDVALUE(
            Blanks[Field1],
            BLANK()
        )
    ),
    BLANK(),
    SELECTEDVALUE(
        Blanks[Field2],
        BLANK()
    )
)

Hopefully that helps.

[Anonymous]

the solution seems to be limited...what if I add a thousands columns?... if it is gonna be that complicated to have an empty table...maybe I wont do it.

Let me show you the real pbix to see your opinion. I need to know if it worth it

https://www.dropbox.com/s/jjbpvzm4jbyaf9a/DATOS_JEFE_APTO.pbix?dl=0 

[edhans]

If you add thousands of columns, then you might want to rethink doing this in Power BI. 😉 I cannot imagine the scrolling left/right.

I am not aware of a way to do it with out a series of measures, either in the actual columns, or fields. Your original sample only had fields, no measures or amounts, so that is why I did it the way I did.

Personally, I'd  let the table show everything. Don't make your users know what they are looking for. Your approach prevents browsing the data, especially since you aren't using slicers, just text boxes to filter on.

[Anonymous]

ohhh... too bad news super user.

Thanks anyways

[edhans]

Sorry we weren't able to get you exactly what you wanted @Anonymous - I marked my answer for your 2 column example as the solution as it did answer the specific data you provided. But for thousands of columns, it really won't work. That wasn't in the original request.