The measure shows me more data than necessary

[apcor0301]

Hi

Consumo Soles =

    SUMX('Consumos Pareto LYM', 'Consumos Pareto LYM'[Valor Soles])

Cat ABC2 = CALCULATE([Consumo Soles], ALL('Consumos Pareto LYM'[Número de artículo]))

 I do not understand why it shows me items that do not belong to the line of business that I am filtering if I am only applying the ALL function on the column 'Consumos Pareto LYM'[Número de artículo]

The relational data model is like this:

Best

Anthony

[apcor0301]

Hi amitchandak

I modified the measure as you suggested and made sure that the "show items without data" option was disabled, but it still shows the same result. The strange thing about this is that the articles that I highlighted in the yellow circle do not even belong to the line of business "monitoring and condition" which is selected. But the measure does calculate only the total that corresponds to this line of business

[amitchandak]

@apcor0301 , Try like

Consumo Soles =
SUMX('Consumos Pareto LYM', 'Consumos Pareto LYM'[Valor Soles])
Cat ABC2 = CALCULATE([Consumo Soles], ALLSelected('Consumos Pareto LYM'[Número de artículo]))

Also make sure this option is NOT enabled