March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello experts,
I hope you can help me.
I put them in context.
I have three databases:
Two new tables are created from those databases:
The relationships are as follows:
Below you can see that I have two measures:
Contracted tracer services: Counts the number of tracer services contracted in each city
Plotter Services Enabled: Counts the number of plotter services enabled in each city
In the table on the left you have the number of plotting services contracted and on the right the plotter services enabled.
My intention is to:
Show in the table on the right only the tracer services that are not contracted in each of the municipalities.
As illustrated below:
I hope you can help me.
Thanks a lot
Solved! Go to Solution.
I suggest you eliminate the many-to-many relationship between your Servicios_habilitados (Nombre_municipio) and CONTRACTED SERVICES (MUNICIPIO).
Instead, create a Dimension table for unique "municipalities" values and create one-to-many relationships between this Dimension table and Servicios_habilitados (Nombre_municipio) and CONTRACTED SERVICES (MUNICIPIO).
To identify services that have not been contracted to us:
Services not contracted ?
VAR CONtServices - VALUES(SERVICIOS_CONTRATADOS [COD_SERVICIO]
VAR ServObl - VALUES(SERVICIOS_TRAZADORES[COD SERVICE]
Return
COUNTROWS(EXCEPT(ServObl, ContServices)
Proud to be a Super User!
Paul on Linkedin.
Hello @JuanDtM23 ,
Depending on my understanding of your description, you can create a measure for the visual level filter:
Measure = var a =CALCULATETABLE(EXCEPT(VALUES(Servicios_habilitados[serv_codigo]),VALUES('SERVICIOS CONTRATADOS'[COD_SERVICIO]))) return IF(MAX(Servicios_Trazadores_Habilitados[COD])in a,1,0)
Add it to Services Plotters Enabled table visual level filter and set it to 1:
If this post helps, then consider Accept it as the solution to help other members find it faster.
Best regards
Dedmon Dai
I suggest you eliminate the many-to-many relationship between your Servicios_habilitados (Nombre_municipio) and CONTRACTED SERVICES (MUNICIPIO).
Instead, create a Dimension table for unique "municipalities" values and create one-to-many relationships between this Dimension table and Servicios_habilitados (Nombre_municipio) and CONTRACTED SERVICES (MUNICIPIO).
To identify services that have not been contracted to us:
Services not contracted ?
VAR CONtServices - VALUES(SERVICIOS_CONTRATADOS [COD_SERVICIO]
VAR ServObl - VALUES(SERVICIOS_TRAZADORES[COD SERVICE]
Return
COUNTROWS(EXCEPT(ServObl, ContServices)
Proud to be a Super User!
Paul on Linkedin.
Hello, Thank you very much.
I will try
Hello @JuanDtM23 ,
Depending on my understanding of your description, you can create a measure for the visual level filter:
Measure = var a =CALCULATETABLE(EXCEPT(VALUES(Servicios_habilitados[serv_codigo]),VALUES('SERVICIOS CONTRATADOS'[COD_SERVICIO]))) return IF(MAX(Servicios_Trazadores_Habilitados[COD])in a,1,0)
Add it to Services Plotters Enabled table visual level filter and set it to 1:
If this post helps, then consider Accept it as the solution to help other members find it faster.
Best regards
Dedmon Dai
Hi @JuanDtM23 ,
Is there any column to distinguish between municipalities and ordinary cities? Or you can create a measure for it and add it to visual level filter on the right table.
It is difficult to understand your requirements only through your description, perhaps you can provide some sample data.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hello @v-deddai1-msft ,
No, the Contracted Services table has a column called "Municipality" which contains both ordinary cities and municipalities, for its part the table "Servicios_Habilitados" has a column called "Nombre_Municipio_" which also contains ordinary cities and municipalities.
I attach the . Pbix for greater understanding:
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
99 | |
90 | |
72 | |
62 |
User | Count |
---|---|
140 | |
121 | |
106 | |
98 | |
94 |