DAX Query -.Get me the name of the customer who did the most sales in Bikes

[Suganya_Hemanth]

EVALUATE

{

VAR a=Sales

VAR b=SUMX(a,FILTER(Products,'Products'[Category]="Bikes"))

VAR c=FILTER(Customers,'Customers'[Name]=b)

RETURN

c}

I am not getting answer for this.if anyone knows kindly let me know. Here Sales,Customers,Products are different tables.

[Anonymous · Accepted solution]

Hi @Suganya_Hemanth ,

Here some steps that I want to share, you can check them if they suitable for your requirement.

Here is my test data:
Customers table:

Products table:

Sales table:

1.Create a measure

Customer = 
VAR max_sales = CALCULATE(MAX(Sales[Amount]), Products[Category] = "Bike")
RETURN
    CALCULATE(
        VALUES(Customers[Name]),
        FILTER(
            Sales,
            Sales[Amount] = max_sales &&
            RELATED(Products[Category]) = "Bike"
        )
    )

2.Final output

Best regards

Albert He

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

[some_bih]

Hi @Suganya_Hemanth assuming your model is model similar to DAX.DO, please check link with example.

Adjust your table / columns name.

[Suganya_Hemanth]

Thanks to help in this.

Can i do the same without using Calculate Functions, ie by using variables.