I need help

[Syndicate_Admin]

Hello, I need help:

I have to make a new column Half kilos Patatas that will be the result of calculating the average kilos of the products of type Fruits and Hortalizas that are potatoes, which have been marketed for each province.

In the column Description Variety I have several types of Potatoes, the column Type Product contains products type Fruits and vegetables, fish and meat. The Origin column of the Products table and the Origin column of the Provinces table are associated with a province in the Origin Description column.

Thanks in advance

[Anonymous]

Hi @Syndicate_Admin ,

Please have a try. Create a measure.

Measure=CALCULATE(AVERAGE('Table' [KilosCame]),FILTER(ALL(Table),'Table'[Descrikion Origen]=SELECTEDALUE('Table'[Descrikion Origen])))

 If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.