Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
hi Guys,
How can I adjust my measurement to obtain the number of brokers that correspond to each project considering the beginning and end of the project
I have the following model.
My measurement is not considering the selected project
contagem =
VAR vMinData = MIN(d_calendario[Date])
VAR vMaxData = MAX(d_calendario[Date])
VAR InicioProjeto = MAX(projetosReaal[Inicio do Projeto])
RETURN
CALCULATE(
DISTINCTCOUNT(_corretores[Corretor Ajustado]),
InicioProjeto <= vMaxData &&
_corretores[data_cad] < vMaxData &&
_corretores[Data de saida] <= vMaxData
)
Hi,
Share some data to work with and show the expected result very clearly.