Forum Discussion

MikeO's avatar
MikeO
Helper I
6 years ago

Non-Key Column in my Dimension Table Not Filtering my Fact Table

I have a transaction type column for filtering types of transactions (i.e., sale, cancelled, returned, replacement, etc.) and I created a dimension table with a key for every transaction type.  I the...
Need Help
Show and Tell
mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi MikeO ,

 

can you share some screenshots?

Especially from the model view.

 

MikeO's avatar
MikeO
Helper I
6 years ago

Hi mwegener , here are some screenshots:

report with only Transaction Type, no Transaction Type Key

 

report with both transaction type key and TransactionType column, you can see patient_id 0006242 only appears once now

 

Image of relationship created between the two tables:

 

 

 

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Community Support
    6 years ago

    Hi MikeO ,

     

    We have a little confused about your issue.

    In the table visual, which table does [Transaction Type] belong to?

    What is the field after [Transaction Type]?

     

    We suggest to create another dim table that just contains unique Transaction Type.

     

    New dim table = DISTINCT('Fact Table'[Transaction Type])

     

    Then create an one-to-many relationship between fact table.

     

     

    At last you can create a table visual using New dim table[Transaction Type].

     

    If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data?

    It will be helpful if you can show us the exact expected result based on the tables.

     

    Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.