Forum Discussion

aqavi10's avatar
aqavi10
Icon for Advocate I rankAdvocate I
7 years ago
Solved

Top value in a category based on 2 columns

Hi everyone,     Can someone please help me accomplish this task below? I need to display the store with the highest sales in a 'Card' visual. This needs to be categorized based on the 'State' and ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

See if this measure works

Store(s) with highest sales = CONCATENATEX(TOPN(1,GENERATE(VALUES(Data[StoreName]),VALUES(Data[Week])),[Revenue]),Data[StoreName],", ")