Measure for counting products with multiple value filters

[ckleppe]

Hi all,

I am working on a report for new product development. 

There are some KPI's (numbers) I want to show.

For example:

Count of products that reach >= 20000kg's or >=7500 margin. 

So 2 filters from different value sources (weight and margin)

The idea is very simple, but I can't figure out a solution to count the products....

Thanks in advance

Camiel

[amitchandak · Accepted solution]

@ckleppe ,

Try like

countx(filter(summarize(Table,Table[product],"_r",sum(Table[reach]),"_m" ,sum(table[margin])),[_r]>=20000 || _m >=7500 ),[product])

[ckleppe]

@amitchandak It's working, thanks!!