Visual filter by Measure or maybe Conditional filter

[Mera9]

There is a card that shows Yes or No. Then there is a table with 3 columns (Name, Number, Next Audit). Here is a measure for a card:

Audit (Card) =
VAR HasOverdue =
CALCULATE(
COUNTROWS('AUDIT'),
'AUDIT'[Audit] = "Overdue"
)

RETURN
IF(HasOverdue > 0, "Yes", "No")

So when I select a specific date and Country, the card shows me Yes or No.
How can I filter the rows that contain only the values which I see on the card?

[v-kpoloju-msft]

Hi @Mera9,
Thank you for reaching out to the Microsoft Fabric Community Forum. Thank you @Cookistador, for your inputs on this thread.

Right now, the card and table are independent the table does not filter itself based on the "Yes"/"No" shown on the card.

• Visual-level filters in Power BI don't directly reference a value from another visual (card → table).
• Measures cannot directly control visual filtering unless specially designed.

They are missing a dynamic connection between the Card's logic and the Table filtering.

Create a New Measure to Filter the Table:

Show Row Based on Audit Card =

VAR HasOverdue =

    CALCULATE(

        COUNTROWS('AUDIT'),

        'AUDIT'[Audit] = "Overdue"

    )

RETURN

IF(

    HasOverdue > 0 && 'AUDIT'[Audit] = "Overdue",

    1,

    0

)

Now, go to the Table visual:

• Drag Show Row Based on Audit Card into the Filters pane of the Table.
• Set the filter to show only when Show Row Based on Audit Card = 1.

This way:

• If the card says Yes (overdue audits exist), the table only shows "Overdue" rows.
• If the card says No (no overdue audits), the table will show nothing.

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

[Mera9]

This is not the right logic. If I select Country, and the table shows me 30 rows (columns Name, Number, Next Audit) where 2 are 'yes' and 28 are 'no', then in the card it shows 'yes', and in the table I need to see only 2 'yes'. And if there are absent 'yes' values, then I need to see 'no' in the card and just rows that include 'no' values in the table.

[v-kpoloju-msft]

Hi @Mera9,

Thank you for your follow up and for clearly explaining the behaviour you're expecting.

You're right, the previous logic doesn't filter the table based on the card’s output. To align the table with the card’s logic dynamically, we can use a measure that adapts row level visibility depending on whether "Overdue" values are present in the current filter context.

Revised Dax:

Show Row Based on Card =

VAR HasOverdue =

    CALCULATE(

        COUNTROWS('AUDIT'),

        'AUDIT'[Audit] = "Overdue"

    )



RETURN

IF(

    (HasOverdue > 0 && 'AUDIT'[Audit] = "Overdue")

    || (HasOverdue = 0 && 'AUDIT'[Audit] <> "Overdue"),

    1,

    0

)

Drag Show Row Based on Card into the Filters on this visual pane. Set the filter to is = 1.

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

[v-kpoloju-msft]

Hi @Mera9,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-kpoloju-msft]

Hi @Mera9,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-kpoloju-msft]

Hi @Mera9,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-kpoloju-msft]

Hi @Mera9,

Could you please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Thank you.

[v-kpoloju-msft]

Hi @Mera9,

We are following up once again regarding your recent query. To proceed further, could you kindly provide sample data that fully represents the issue or question in a usable format.

If we do not receive a response, we will proceed to close this thread. Should you require further assistance in the future, please feel free to post a new thread on the Microsoft Community Forum Our team will be more than happy to assist you.

Thank you for your understanding and continued participation.

[Mera9]

Hi,
I didn't find the solution, so I changed the approach. Please close this thread.
Thank you.

[v-kpoloju-msft]

Hi @Mera9,

Thank you for confirming the change in approach and that the thread can be closed. Should you require further assistance, please create a new thread in the forum, and we will be glad to assist you.

Thank you for using the Microsoft Community Forum.

[Cookistador]

You have to add your measure in the Table to be able to filter with it

When I have to do that, I add the mesure and I hidde it (replace the name by a space and give the same color to the font and the background color)

[Mera9]

Then I see just a column with Yes and No in all rows.