Forum Discussion
Creating an Alias based on associated name
Location Name TABC Sales (YTD) TABC Sales (TTM) TABC Sales (Current Month) TABC Sales (PY) TABC Sales (Prior Month) TABC Sales MoM % TABC Sales YoY % TABC Sales YoY % (YTD) TABC Sales YoY % (TTM) BOTTLED BLONDE- THE BACK YARD (DALLAS - 75204 - 1) $13,016,303 $13,016,303 $1,182,779 $372,854 $1,029,192 14.92% 217.20% 194.80% 194.80% LEVY RESTAURANTS (DALLAS - 75219 - 7) $5,954,354 $5,954,354 $1,142,662 $0 $1,695,755 -32.62% 56.10% 56.10% NICK & SAM'S STEAK & FISH HOUSE (DALLAS - 75201 - 1) $8,087,528 $8,087,528 $873,895 $541,321 $828,036 5.54% 61.40% 73.80% 73.80% HAPPIEST HOUR, LLC (DALLAS - 75201 - 1) $9,912,106 $9,912,106 $780,166 $472,946 $707,536 10.27% 65.00% 262.50% 262.50% DFB CAPITAL LLC (DALLAS - 75201 - 2) $9,453,849 $9,453,849 $739,814 $536,407 $751,047 -1.50% 37.90% 61.60% 61.60% HOSPITALITY INTERNATIONAL INC (DALLAS - 75201 - 65) $6,200,159 $6,200,159 $726,701 $367,193 $569,841 27.53% 97.90% 100.20% 100.20% BIERNAT'S RESTAURANT (DALLAS - 75219 - 1) $5,850,108 $5,850,108 $715,103 $400,024 $544,627 31.30% 78.80% 84.60% 84.60% COWBOY'S RED RIVER (DALLAS - 75220 - 1) $5,893,024 $5,893,024 $655,404 $263,585 $490,769 33.55% 148.60% 126.00% 126.00% MKRDY DALLAS BEVCO LLC (DALLAS - 75202 - 1) $3,406,276 $3,406,276 $599,536 $301,577 $384,309 56.00% 98.80% 104.10% 104.10% ROUNDUP SALOON (DALLAS - 75219 - 4) $6,778,924 $6,778,924 $599,022 $302,119 $538,619 11.21% 98.30% 269.30% 269.30% THE HENRY (DALLAS - 75201 - 1) $4,157,863 $4,157,863 $590,569 $362,336 $396,364 49.00% 63.00% 67.60% 67.60% COOL RIVER CAFE CRC01 (DALLAS - 75235 - 1) $3,332,072 $3,332,072 $581,503 $273,041 $319,202 82.17% 113.00% 103.30% 103.30% EPIC ABS LLC (DALLAS - 75201 - 1) $5,385,330 $5,385,330 $562,596 $315,715 $378,029 48.82% 78.20% 62.00% 62.00% OMNI DALLAS CONVENTION CENTER (DALLAS - 75202 - 18) $5,350,773 $5,350,773 $556,890 $120,919 $684,945 -18.70% 360.50% 22.50% 22.50% BABY DOLLS TOPLESS SALOON (DALLAS - 75220 - 1) $5,467,956 $5,467,956 $539,655 $306,499 $503,023 7.28% 76.10% 106.60% 106.60% CITIZEN DALLAS (DALLAS - 75204 - 1) $5,749,373 $5,749,373 $534,565 $0 $506,220 5.60% 0.00% FULLER BIERNAT BEVERAGE LLC (DALLAS - 75254 - 1) $3,759,075 $3,759,075 $529,031 $243,437 $328,842 60.88% 117.30% 103.70% 103.70% VIDORRA (DALLAS - 75226 - 1) $7,052,381 $7,052,381 $527,870 $305,056 $498,992 5.79% 73.00% 92.90% 92.90% THOMPSON DALLAS BEVERAGE, LLC (DALLAS - 75202 - 1) $3,698,712 $3,698,712 $520,613 $170,224 $384,655 35.35% 205.80% 1662.80% 1662.80% SIDECAR SOCIAL (DALLAS - 75254 - 1) $5,339,420 $5,339,420 $505,700 $302,755 $452,840 11.67% 67.00% 45.20% 45.20% VIRGIN HOTELS DALLAS (DALLAS - 75207 - 1) $6,644,115 $6,644,115 $497,410 $405,964 $278,642 78.51% 22.50% 41.60% 41.60% DD BEVCO, LLC (DALLAS - 75202 - 1) $6,468,383 $6,468,383 $496,797 $298,282 $522,302 -4.88% 66.60% 133.00% 133.00% JAVIER'S RESTAURANT (DALLAS - 75205 - 1) $5,225,867 $5,225,867 $495,558 $339,547 $451,671 9.72% 45.90% 63.70% 63.70% OJOS LOCOS SPORTS CANTINA (DALLAS - 75220 - 7) $5,404,677 $5,404,677 $488,515 $291,327 $477,008 2.41% 67.70% 54.20% 54.20% PARADISO/BOTANIST/GOOD COMPANIONS (DALLAS - 75208 - 1) $3,573,294 $3,573,294 $485,950 $333,619 $270,084 79.93% 45.70% 49.10% 49.10% TRUE KITCHEN & KOCKTAILS / FLAIR COCKTAIL LOUNGE (DALLAS - 75201 - 1) $5,864,102 $5,864,102 $484,101 $188,583 $498,175 -2.83% 156.70% 552.20% 552.20% Hi AaronGlenn10
You need to make same solution, I shared below post
https://community.powerbi.com/t5/Desktop/Filtering-a-Matrix-to-a-specific-row-level-that-contains-a-Value/m-p/2345857#M845913Lookup Table:- Go to Power Query and create Refernce table with two col "restaurant/location" & "location name + city + zip code + location number" /or create a table with SUMMARIZE dax function
Create relationship:- with "location name + city + zip code + location number" between Lookup table and Main Table
Use "restaurant/location" col from lookup table and data from main table in visulization
If you have any question, please let me know.
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/KudosHi AaronGlenn10
Is requirement is solved, please mark this post as solved.
Hi AaronGlenn10
You need to make same solution, I shared below post
https://community.powerbi.com/t5/Desktop/Filtering-a-Matrix-to-a-specific-row-level-that-contains-a-Value/m-p/2345857#M845913
Lookup Table:- Go to Power Query and create Refernce table with two col "restaurant/location" & "location name + city + zip code + location number" /or create a table with SUMMARIZE dax function
Create relationship:- with "location name + city + zip code + location number" between Lookup table and Main Table
Use "restaurant/location" col from lookup table and data from main table in visulization
If you have any question, please let me know.
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos