Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear All,
I have a table having field city name, now in another table some city doesn't have any stores so I want to give filter where only shows only those name which has stores, not those which doesn't have city but there is one thing that in future they can open/map some stores in that cities so those should be coming when it has value..
please help me how can i calculate this??
rgrds,
arif
Solved! Go to Solution.
Hi @Anonymous ,
Here are the steps you can follow:
1. Create measure.
Measure_Count = COUNT('Fact Table'[Region Code])
2. Place [Measure_Count] in the Filter that forms a slice with [Region Code], and set is not blank.
3. Result:
After adding a piece of data, AJM also has data, which will also be displayed normally in the slicer
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Anonymous ,
Here are the steps you can follow:
1. Create measure.
Measure_Count = COUNT('Fact Table'[Region Code])
2. Place [Measure_Count] in the Filter that forms a slice with [Region Code], and set is not blank.
3. Result:
After adding a piece of data, AJM also has data, which will also be displayed normally in the slicer
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
@Anonymous Tried to replica your issue at my end.
This is not what I am asking my friend,
i am asking that if i put the city filter it will show all the cities including those which has no stores in another tables
if I unselect the way you mentioned but let's say tomorrow if they open store then that will open then it will not show in the filter so i have to make a calculated column which should work dynamically.
rgrds,
arif
@Anonymous Create Calculated column like below:
CALCULATED COLUMN = If(Table[City] = Blank(),1,0)
Then Take your City field in the Slicer and in Visual Filter of this Slicer just use the above new column and filter to 0. So it will show up only available city in your slicer.
Thank you for reply my scenario is
City Table
Region Code | Region Name |
DXB | Dubai |
ABD | Abu Dhabi |
AJM | Ajman |
RSK | Ras-Al-Khaima |
SHJ | Sharjah |
UMQ | Umm-Quwayn |
FJH | Fujairah |
FACT Table
Region Code | Store ID | Store Name |
DXB | St001 | ABC Plaza |
DXB | St002 | BCD Plaza |
DXB | St003 | CBD Plaza |
ABD | St004 | DEF Plaza |
ABD | St005 | EFJ Plaza |
ABD | St006 | FJK Plaza |
now i have two tables
I only want those city names in my fillter which has stores but it should work dynamically, let's say tomorrow they open any store in different region then it should be coming there..
Please support
rgrds
arif
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |