filter column of dim table if rows exists in id column in the fact table

[akhaliq7]

I have a dimension table with too many rows, My fact table contains less rows as I have filtered it down.I can't apply the same filtering on the dim tables as it returns blanks when I display them in a visual, also another trick is doing merges in power query but I am getting performance issues with this trick. I was looking for an option using dax to see if I can return rows based on if it matches the id column in the related fact table. I am using a star schema so not sure if the related or relatedtable functions may work.

[akhaliq7]

Thanks ill try this way i think it will work as someone recommended i do this in another question i posted on the power bi cimmunity for power query.

[tamerj1 · Accepted solution]

Hi @akhaliq7 

not sure if I fully understand you requirement. But you can try

Filter Measure = COUNTROWS ( fact_table[id] )

then place it in the filter pane and then select "Is Not Blank"