topic RELATIONSHIP USING TREATAS in DAX Commands and Tips

RELATIONSHIP USING TREATAS

carolinesbp_ — Mon, 25 Mar 2024 13:23:34 GMT

Hey guys!!
I need to relate two tables, the METAS table and the CONTRACTS table.
Both have a relationship with the calendar table, so I can't relate them directly.
I created a new table containing the seller columns and related both to this table and it returned an active relationship, but any other column or even creating a new table, Power BI does not allow the relationship.

With this, I created a measure using treatas:
Novos Clientes =
CALCULATE(
COUNTROWS(CRM_CONTRATOS),
CRM_CONTRATOS[ClassificacaoCliente] = "Novo",
TREATAS(
VALUES(CRM_CONTRATOS[LINHA]),
'01. Meta'[Linha]
),
TREATAS(
VALUES(CRM_CONTRATOS[ProdutoGPOM]),
'01. Meta'[Serviço]
)
)

This formula returns the expected result, but the filters in the METAS table columns do not work to filter this measure.
Example:
The filters for the saller and teams columns filter correctly, but the service and location do not filter this measure correctly.
as below: it filters correctly
IMAGE 01

but when I filter with another filter it doesn't work. he doesn't even filter
IMAGEM 02

all filters come from the METAS table.
The rek?lationship is like this

IMAGEM 03.

What can I do to fix this? There is another method for filters and relationships to worK?

Re: RELATIONSHIP USING TREATAS

Greg_Deckler — Mon, 25 Mar 2024 13:30:41 GMT

carolinesbp_ You can create an inactive relationship and then use USERELATIONSHIP to activate the desired relationship in a measure calculation.

Re: RELATIONSHIP USING TREATAS

carolinesbp_ — Mon, 25 Mar 2024 13:36:38 GMT

Hi Greg! How I can do this? The issue is that the filters in the METAS table don't work and I needed to relate them to the measures, but keeping what I already have.

Re: RELATIONSHIP USING TREATAS

Greg_Deckler — Mon, 25 Mar 2024 13:47:42 GMT

carolinesbp_ Extremely difficult to determine where the issue is without sample data to recreate. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.