Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power BI Model

Hi,

I have a model like below. Fact mission hours has a column 'Region' and for specific set of Task Ids (from Dim Task) will be associated to a particular region. The same set of specific task ids will have multiple region names in the fact current hours table. With what I have in the model I get the correct data. The problem is that the 'measure 3' and 'region name' (comes from fact mission hours table is repeated for each record. I want to show the 'region name' and the 'measure3' to be placed against only in the matching record with the'fact current hours table. Please advise.