Category value different from total value per customers

[WillianRamos1]

Hi, I have a problem on my dashboard, where I choose the number of TOP customers I want and it brings me the total value of the sum of these customers, but in the category chart it doesn't work. it lists the total values without the TOP clients filter that I chose.

i select how many a wantshow the total os customers by the quantity i chose on filtershow a total value of the selected qty customershere is the error, he is not filteing by TOP qty, he show the all value of billing

Measures i using..................I'm not sure if they are ideas, but that's how I managed to list the TOP as I choose the quantity in the TOP clients chart.

TopN Customers=

var vRanking =

RANKX(

    ALL('sqldatabase'[customerName]),

    [invoicing_Total]

)

RETURN

IF(

    vRanking <= TopCustomers[TopCustomers Value],

    [invoicing_Total]

)

Test Category =

CALCULATE([invoicing_Total], TOPN(TopCustomers[TopCustomers Value],

ALLSELECTED('sqldatabase'[customerName]),

[[invoicing_Total])

)

[nick_potts]

You've verified that the visual IS being impacted by the topn filter? What is the relationship between products and customer?

[WillianRamos1]

So, in this example case that I showed you there, if I click on a customer there in that "TOP CUSTOMERS" graph, it filters the correct values for each category, but only when I select a specific CUSTOMER.

There are 3 tables, one for CUSTOMERS, one for INVOICES and the other for PRODUCTS, but this one for products is an excel file that people from the company fill in according to the sale of products, which in this case always has 4 or 5 products per month.

The tables are linked as follows:

In the INVOICES table, there is a CLIENT ID that references the CLIENTS table, so CLIENTEID is the foreign and primary key.

The other relationship is with the PRODUCTS table............in the INVOICES table there is a field called "product type" which in this case is a text field, and in the products table there is also this field, they are related by this "PRODUCT TYPE" but in this case it is a text field that has a nomenclature of the product, for example AXH23 H - CHEU23 C - POED22 P.