Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Pass Power Bi desktop report builder parameters

Hello everyone,
I have a problem where I have two fact tables linked to one dimension. I use fact table values as if they were slicer filters. These filters are used to filter the entire report and sub-reports. I would like to be able to pass filters attached to fact tables to the parameters of a paginated report placed in power bi desktop. My problem arises when placing the columns of one fact with the columns of another fact Power Bi tells me that they cannot be inserted because a relationship between the tables is missing. My only relationship is that between a dimension and the two facts. So the two facts are not connected by themselves. The relationship to size is one to many with filter from size to fact.
Is there a way to pass the values of the two fact tables within the paginated report without going wrong? I was thinking of a measure or a calculated column that would take the values of both facts.
I ask for your help.

A greeting

1 Reply

  •  I use fact table values as if they were slicer filters

    That's what dimension tables are for.  Fact tables count/aggregate, dimension tables filter.