Forum Discussion
aqavi10
Advocate I
Advocate ITop 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 ...
Ashish_Mathur
Super User
Super UserHi,
I am not sure of how much I can help but I would like to try. Share your PBI file with data for a few weeks. In your previous posts, your file had data only for one week.
aqavi10Advocate I
Advocate IHi Ashish,
The data file shared before has a table named as 'Sample' . I reckon, that should be useful with multiple weeks of data.
Lastly, thanks again for looking into this.
- Ashish_Mathur
Hi,
That takes me to a sign-in page.
- aqavi10
- Ashish_Mathur
Hi,
See if this measure works
Store(s) with highest sales = CONCATENATEX(TOPN(1,GENERATE(VALUES(Data[StoreName]),VALUES(Data[Week])),[Revenue]),Data[StoreName],", ")