Forum Discussion
Calculate From Another Table And Apply Filters From Other Table
Below is a screenshot of a very simple example of what I am trying to do. The PClaims is the raw data. Notice in yellow, B is missing Code "2". In my base table, I have it set up so that each affiliation_II has each code, so there is a line for Affiliation_II B and Code "2". The reason I have this Base table instead of just using PClaims is so that each Affiliation_II has every single code, even if it is missing in the raw data.
Super Usergillyr7 what is =CommunityProf table?
Are you creating base table using DAX expression you put in your original post?
No, this is Base Table is created using Power Query. In PowerQuery, I have a table with every code, and I duplicate a PClaims query and group by the Affiliation_II. Then I merge these two together with all rows from both to get every Affiliation_II with every code.
The base table is CommunityProf. I was calling it the base table because that is where the formula was residing.