Forum Discussion

iamprajot's avatar
iamprajot
Icon for Responsive Resident rankResponsive Resident
8 years ago
Solved

How to write this Condition in Power BI

I need the Name of the Product from TableA for which I have recieved most Quotes. for e.g. Select Name of Product where Max ( Count (Quotes ) )   Also the Name of the Product from TableA for which...
Need Help
  • iamprajot's avatar
    iamprajot
    8 years ago

    It is working and I am accepting it as a solution however if you could tell me any other simpler way then it would be great as it seems a lot confusing.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Perhaps something along the lines of:

 

MyMax = CALCULATE(MAX(Table([Product]),FILTER(Table,MAXX(Table,COUNT([Quotes])))
iamprajot's avatar
iamprajot
Icon for Responsive Resident rankResponsive Resident
8 years ago

This is exactly what I am using and it seems very feasible but it is not giving desired results always.

I am using slicers/filters and it ives correct results for some and incorrect result for the rest.

I don't know on what basis it is giving rubbish results.