Doubt with measure that summarizes but then cannot be used in filter

[mmm286b]

I have a single Oracle table that I load into PowerBI.

This table has many records of different dates and times (logdate and logtime); they are String fields.

In the BI report, I have a segment data where I can select a specific date.

The report also has visual cards that include measures that summarize by a field in the table. It shows me the number of records grouped by a specific field in the table for that day.

The problem is that when I click on that card, I don't see that  the details of that summary in the visual table associated with the table.

I understand it's because I use the summarize function.

Could you help me achieve this? Is there a trick?

Thanks and best regards,

[v-venuppu]

Hi @mmm286b ,

Thank you @Nabha-Ahmed for the prompt response.

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

[Nabha-Ahmed]

Hi @mmm286b 

The issue happens because you are using SUMMARIZE to build a table. A Card visual only works with measures (single values), not table expressions. That’s why clicking on the card does not filter the detail table.

👉 The trick is: create a measure that returns a scalar instead of a summary table. For example:

RecordCount =
COUNTROWS(Logs)

Or if you need the count by category

ErrorCount =
CALCULATE(
COUNTROWS(Logs),
Logs[ErrorCode] = "SomeValue"
)

Also make sure your logdate and logtime columns are converted to proper Date/Time types in Power Query. If they stay as text, slicers and filters may not work as expected.

Thanks✨🌹

[v-venuppu]

Hi @mmm286b ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @SwarnaTeja for the prompt response.

The issue happens because SUMMARIZE breaks filter propagation, so the card can’t cross-filter the table.

Instead of using SUMMARIZE, write a measure that respects the natural filter context.

Example:

Record Count = COUNTROWS ( 'TableName' )

or, if grouping is needed:

Record Count by Group =
CALCULATE (
COUNTROWS ( 'TableName' ),
ALLEXCEPT ( 'TableName', 'TableName'[GroupField] )
)

Using this measure in the card lets you click it and see the filtered detail rows in the table natively.

[SwarnaTeja]

Hi @mmm286b ,

Yes it can't filter out the table visual. Please try this way .

Duplicate the table visual and pull the measure into the duplicated one. And then filter out those rows with measure value is null to achieve required rows.

Now add a transaparent button on the Measure card which will display the filtered table visual when clicked using bookmarks.