How to filter on a level OTHER than the lowest

[Anonymous]

Hi All!

I would like to know if there is a function or formula to solve the following problem. I want to create a new KPI to show the % of brands which are in the top-left side of the following chart (blue dots) out of the total:

Y axis: Uplift Volume %

X axis: ROI Sell In €

Dimension: Brand

Size of dots: Promotional Volume (Liters)

To do so, I have created the following formula in DAX: 

The problem is that the Primary Key (PK) of DimProducto table is the product, not the brand. Brand is the father of product dimension within the Brand-Product hierarchy in the DimProducto table.

One solution would be creating a new table in the data model which his PK was Brand, but I would prefer to solve it through a DAX formula as it is more scalable.

Thank you very much in advance for your help! 🙂

*Note: "Marca" means Brand in spanish, and "Volumen Promo" means Promotional Volume.

[Anonymous]

Hi @v-yalanwu-msft ,

Of course. My DimProducto table has the following structure:

See that the Primary Key (PK) is the dimension Product, not Brand. Thanks!

[v-yalanwu-msft]

Hi, @Anonymous ;

According to the information you provided, it is difficult to clearly understand your table structure. Can you share simple files after removing sensitive information? Or more information?

Best Regards,
Community Support Team_ Yalan Wu

[Anonymous]

@amitchandak @v-yiruan-msft do you know what I might be looking for? 😇