Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Display exclusive values in a table

Hi, I have 2 tables: Bucket Master: Flavor Name Bucket P1 Premium P2 Premium P3 Premium K1 KK K2 KK K3 KK K4 KK K5 KK L1 LC L2 LC L3 LC PF1 PF...
Need Help
  • Natallia_23's avatar
    Natallia_23
    4 years ago

    Hi,
    try two these measures:

    Flavors Present =
    DISTINCTCOUNTNOBLANK('Flavor List'[Flavor Name])
     
    Missing Flavors =
    CONCATENATEX (
    FILTER ( 'Flavor Master' , NOT [Flavor Name] IN VALUES ( 'Flavor List'[Flavor Name] ) ),
    [Flavor Name],
    ","
    )
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Natallia_23, there's a small problem:

BucketTotalFlavors PresentMissing Flavors
KK32K2, PF1,PF2,PF3,PF4
PFF31PF2,PF3,K1,K2,K3

 

If total column has same number of flavors, the context which power BI considers takes a hiccup and it'll mix and match for those 2 buckets.

 

Any help on how to handle this will be appreciated.