Forum Discussion

Alberto95's avatar
Alberto95
Frequent Visitor
2 years ago

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

 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

 
Need Help
Show and Tell
Tutorial Requests

2 Replies

  • sjoerdvn's avatar
    sjoerdvn
    Solution Sage
    2 years ago

    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.

    • Alberto95's avatar
      Alberto95
      Frequent Visitor
      2 years ago

      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.