How to display data filtered from imported table

[wokka]

Hi

I have a SQL Server table that I have connected to my desktop powerbi ( it has a local model ).

The table appears as a dimension/table  called "AA_Data"  and has columns called  [ID]  and  [trace].

What I wanted to do is drag in both columns from AA_Data  into a simple table on the desktop , but filter the data so we can display only one part of the table data.  

So table looks like this as unfiltered data :

[ID]   [trace]

X      1

Y      2

Z      3

But I wanted to filter out everything except Y and display this :

[ID]   [trace]

Y      2

How could I do that please?

Thanks in advance

[v-pnaroju-msft]

Hi @wokka,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank you.

[v-pnaroju-msft]

Thankyou, @Ritaf1983, @ryan_mayu, for your response.

Hi @wokka,

We would like to check if the solution provided by @Ritaf1983 and @ryan_mayu has resolved your issue.

If you found the response helpful, please mark it as the accepted solution and add kudos. This recognition benefits other members seeking solutions to similar queries.
Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.

[Ritaf1983 · Accepted solution]

Hi @wokka 

Simple filter will do the job :

The pbix with the example is attached

If this post helps, then please consider Accepting it as the solution and giving Kudos to help the other members find it more quickly

[wokka]

Hi

I am familiar with using filters on a page, what I wanted to know was how we would do it using DAX please?

[Ritaf1983]

Hi @wokka 

measure_ = CALCULATE(sum('Table'[trace]), FILTER('Table','Table'[id]="Y"))

The updated pbix is attached

If this post helps, then please consider Accepting it as the solution and giving Kudos to help the other members find it more quickly

[wokka]

I'm just wondering why use SUM if we only want to list ( not summing them ) any rows that have "Y" in [ID} column please? Or maybe I'm missing something about DAX use maybe?

In SQL I'd write this as :      Select * from AA_DATA where [ID] = 'Y'

[Ritaf1983]

Hi @wokka 

SQL is a query language.
Power BI is a data visualization platform.
The working logic between these two is fundamentally different.

For example, in Power BI, a table visual is the only one that fully supports displaying raw, non-aggregated values. Other visuals typically require aggregations.
Also, DAX is not a query language like SQL – it's designed primarily for creating calculations based on filter context within a data model.

Power BI is not a "report generator" in the same way SQL is used for retrieving rows from a database.
Instead, Power BI is model-driven. It relies on a semantic model, with filters and measures built on top of it.

So:

If you're trying to filter data at the report-wide level, this should be handled during the ETL phase, in Power Query.

If you're filtering for visual display only (not part of a calculation), then it's best to use slicers or built-in UI filters.

If you're insisting on handling this through DAX, there are some technical workarounds, for example:
Measure_ = IF(MAX('Table'[id]) = "Y", MAX('Table'[id]), BLANK())

But that’s not a best practice. It’s a workaround for very specific scenarios, and not how DAX is generally intended to be used.

P.S. I adjusted your table so that “Y” can now appear in more than one row.

The updated pbix is attched

If this post helps, then please consider Accepting it as the solution and giving Kudos to help the other members find it more quickly

[wokka]

Hi

Thanks for the extra info. Ive been kind of dropped into powerbi work, after many years in purely SQL. Its a matter of re-calibrating my headspace to work with the powerbi paradigm. 

What drives this is a need to be able to basically dump out data as needed, to be able to confirm data is as we would expect it to be.

Thanks. 

[ryan_mayu]

@wokka 

you can try to add a filter to visual,page or report 

https://learn.microsoft.com/en-us/power-bi/consumer/end-user-report-filter?wt.mc_id=DP-MVP-5004616