Forum Discussion
Calculate From Another Table And Apply Filters From Other Table
I have two tables. My base table is using my PClaims table to calculate a median price by Affiliation and Code which I have in my formula shown below. It works well, except I have a problem when tryi...
parry2k
Super User
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.