Should I have multiple lookup tables?

DAX DAX Calculations
1

I have a fact table that has the following columns:

  • Date
  • Primary Care Provider
  • Billing Provider
  • Servicing Provider

There are other columns (post date, service date, etc), but these are the columns I’m interested in now.

Should I split this table by provider type or should I create special measures that return the provider type?

Thanks in advance for any insight you can provide.

2

When I say “split”, what I mean is that should I create a fact table that has a row for each Primary Care Provider, Billing Provider, and Servicing Provider?

Some records have the same PCP/Billing/Servicing provider.

3

Maybe I should rename my topic to “Should I have multiple records for my fact table”

4

A fact table is expected to have multiple similar records/rows

1 Like
5

Hi @kaDargo - It’s always better to have Single Fact table with multiple fields. If you can get work done using single Fact table, then go with that.

Thanks
Ankit J

1 Like
6

Hi @kaDargo, did the response provided by Antriksh and Ankit help in solving your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.

7

Hello @kaDargo , just following up if the response above help you solve your inquiry?

We’ve noticed that no response was received from you on the post above. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

8

Hi @kaDargo, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.