Wednesday, 15 November 2017

Top City Per State

For Each state display the city name having  highest sales.

Step 1:
Create 3 calculated fields 
1.City Sales   2.Top City Sales     3.Top City Name   by below formulas.




Step 2:
Double click on state geographic dimension, select filled map in marks card shelf, drag and drop Sales measure on color, label of the marks card and drag and drop Top City Name calculated field on label of the marks card.



Thanks Guru's,
Prazval.ks

DAX Time Intelligence Functions

   Thanks Guru's, Prazval.Ks