CODEWITHSUNDEEP
powerbidaxpowerquery
user1274820
user1274820

Reputation: 8144

PowerBI - Use Value in Table View as Filter Parameter

This doesn't seem like it should be too complicated, but I'm not quite sure how to get it working.

I have a table in PowerBI with the following columns:

Table

The columns in the database have an entry for Submitter and QAer

The QAs Posted column is basically just a COUNT of the Submitter

For QAs Pulled, I need to get the count of rows where the particular Submitter (in the first column) is listed as the QAer.

Is this something I can do?

Any help is appreciated, thanks!

EDIT: More about the data model - here's a screenshot example.

InOut

Upvotes: 0

Views: 84

Answers (1)

Marco Vos
Marco Vos

Reputation: 2968

I think you are looking for something like this:

Measure =
COUNTROWS (
    FILTER (
        ALL( 'datatabel' ),
        'datatabel'[QAer] = SELECTEDVALUE ( 'datatabel'[Submitter] )
    )
)

Upvotes: 1

Related Questions