Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Alberto95
Frequent Visitor

Filter Single Measure in a table

Hi, i would like to filter a single column in a table. 

The problem is that if i active a filter in the table all the column are filtered.

i created that measures but the colum doesn't filter

 

Qta AC = CALCULATE(SUM(VENDITE[QTA_CALC]),REMOVEFILTERS(VENDITE[COD_CLIENTE]))
Qta AP = CALCULATE(sum(VENDITE[QTA_CALC]), SAMEPERIODLASTYEAR('Date'[Date]),REMOVEFILTERS(VENDITE[COD_CLIENTE]))
 
Fatt AC = CALCULATE(sum(VENDITE[VAL_NETTO])
Fatt AP = CALCULATE(sum(VENDITE[VAL_NETTO]), SAMEPERIODLASTYEAR('Date'[Date]))
 
VENDITE[COD_CLIENTE] is the field that i want to remove the filter.
 
the table is this
Alberto95_0-1718363377991.png

 the fist two colums will be filtered by VENDITE[COD_CLIENTE] instead the last two columns won't be filtered.

i also try to use ALL, ALLSELECTED without results.

 

can someone help me?

thanks

 
2 REPLIES 2
sjoerdvn
Super User
Super User

So is that filter actually on VENDITE[COD_CLIENTE] or is on some dimension column, with the dimension in a relationship with that column? In that case use ALL('DIM_CLIENTE'), or whatever the table is named.

that tabe are now filtered by the cod_cliente, but cod_cliente is not a column of this visual table. 

the first column of the visual table in the image is "Plat" also a column in the "Vendite" table DB.

there is no relationship because there is only one table in the report.

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.