Hello everyone,
Hope you are all good and safe in this time. I have created a new table (Table 2)based on calculation from Table 1 My table looks like this
Table 1:
| IDNO | Store_Number | Slow |
| AA1 | S1 | y |
| AA1 | S2 | n |
| AA1 | S3 | y |
| AA1 | S4 | y |
| AA1 | S5 | n |
| AA1 | S6 | y |
Table 2:
| IDNO | Store_Number | Affected by |
| AA1 | S2 | S1 |
| AA1 | S3 | S1 |
| AA1 | S4 | S1 |
| AA1 | S4 | S3 |
| AA1 | S5 | S1 |
| AA1 | S5 | S3 |
| AA1 | S5 | S4 |
| AA1 | S6 | S1 |
| AA1 | S6 | S3 |
| AA1 | S6 | S4 |
Because of slow offloading at stores other stores get affected and hence a new table needs to be created as shown above showing the problem causing stores .For example : S4 is affected because of slow offloading at s1 and s3 as both these storesd are marked as "y"
Now Im able to Retreive all the Stores that has affecetd the store in study as below with the following code :
CALCULATE(CONCATENATEX(
SUMMARIZE(
Table2,
Table2[Affected by]
),
Table2[Affected by],
",",
TREATAS(VALUES(Table1[Store_Number]),Table2[Store_Number])) |
I would like the times affected as well such as for example if S4 is under study i would like it to display S1(Times affected), S2(Times Affected) instead of just S1,S2 as code displays .
ANy leads is greatly appreciated _/\_.Thanks
