Forum Discussion

kasife's avatar
kasife
Helper V
2 years ago
Solved

Working with bridge table

Hello everyone in the community

 

Guys, I'm having great difficulty getting a result, could anyone help or guide me? I've been trying for days and I can't get what I want

 

I have the following model

This is what my page looks like: I have a slicer the month and year (MÊS | ANO) and project (Nome  do Projeto Original)
My Sales card (Repasses realizados), Total number of brokers (contagem de corretores) and my matrix (Detalhamento das Equipes) with the name of the project and the broker

 

 


I am using the following measure to distinctly count the total number of brokers

 

COUNTROWS (
    FILTER (
        ALL( _projetos_corretor ),
        _projetos_corretor[Nome Projeto Reaal] = SELECTEDVALUE(projetosReaal[Nome do Projeto Original]
    )
))

 

In my project slicer I am using the column from the Project table.

When I select the project it brings me the corresponding count. 
When there is no selection, it should return the general total of brokers, but it does not return any value

When I select the date, it doesn't bring any value either. It should return me the count of brokers according to the start and end date of each project in the project table
How could I do this?

 

  • that's not yet a data model. Please read about Star Schema, facts and dimensions.  A Bridge table is usually an indication that something's not right with your data model.

1 Reply

  • that's not yet a data model. Please read about Star Schema, facts and dimensions.  A Bridge table is usually an indication that something's not right with your data model.