Hello All,
Could you help me in creating one dax
As I want to create a measure which show simple sales value and where the value is blank I need to show average of sales number on the basis of retailer and Municipal code
Here is the data like this coming from multiple tabes--
| ID CLIENTE | LAT | LONG | RETAILER | SUBADENA | REGIÓN | MUNICIPIAL CODE | Sales |
| 100232400 | 26.944387 | -101.444751 | HEB | HEB | NORTE | ABASOLO | $4062109 |
| 11001 | 16.8531086 | -99.8236533 | HEB | HEB | | Acapulco | |
| 103788432 | 21.8429068 | -102.3193214 | HEB | HEB | OCCIDENTE | AGUASCALIENTES | $2372543 |
| 100600587 | 21.916947 | -102.297159 | HEB | HEB | OCCIDENTE | AGUASCALIENTES | $3941051 |
| 17091 | 21.9166057 | -102.2964434 | HEB | HEB | | AGUASCALIENTES | |
| 7097 | 25.78543 | -100.2251306 | HEB | HEB | | APODACA | |
| 750 | 25.7401272 | -100.1594719 | HEB | MI TIENDA | | APODACA | |
| 7417 | 25.7863 | -100.247979 | HEB | MI TIENDA | | APODACA | |
| 101887434 | 25.784491 | -100.22578 | HEB | HEB | NORTE | APODACA | $14460 |
| 100547439 | 22.2756266 | -97.8331798 | HEB | HEB | NORTE | CIUDAD MADERO | $2828375 |
| 7676 | 25.6493859 | -100.3605432 | HEB | HEB | | Garza García | |
| 20343 | 25.6626225 | -100.3688142 | HEB | HEB | | Garza García | |
| 19920 | 25.6797838 | -100.4168299 | HEB | HEB | | Garza García | |
| 33885 | 25.7845554 | -100.2727853 | HEB | HEB | | GENERAL ESCOBEDO | |
| 9593 | 25.7923791 | -100.3308951 | HEB | HEB | | GENERAL ESCOBEDO | |
| 2092545 | 25.848111 | -100.372641 | HEB | MI TIENDA | | GENERAL ESCOBEDO | |
| 21754 | 25.7940754 | -100.3348131 | HEB | MI TIENDA | | GENERAL ESCOBEDO | |
| 20151 | 25.6788207 | -100.2377411 | HEB | HEB | | Guadalupe | |
| 6025 | 25.6575028 | -100.1830291 | HEB | HEB | | Guadalupe | |
| 18582 | 25.6927006 | -100.2425814 | HEB | HEB | | Guadalupe | |
| 103426897 | 20.696906 | -101.357366 | HEB | HEB | CENTRO | IRAPUATO | $3366096 |
Please assist here
