Difficulty with measures

Question

&nbsp;I have a dax measue that evaluates conditions in the rows of table based on a combination of values from another table:Autorisatie_fact = IF (&nbsp; &nbsp; &nbsp; &nbsp; COUNTROWS (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FACT_Realisatie,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FACT_Realisatie[Kostenplaats_Key] = LOOKUPVALUE(RLS_Rol[Kostenplaats_Key], RLS_Rol[Kostenplaats_Key], FACT_Realisatie[Kostenplaats_Key]) ||&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FACT_Realisatie[Product_Key] = LOOKUPVALUE(RLS_Rol[Product_Key], RLS_Rol[Product_Key], FACT_Realisatie[Product_Key])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; ) &gt; 1,&nbsp; &nbsp; &nbsp; &nbsp; 1,&nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; )&nbsp;There are purposefully no relations between the tables. I have another measure that returns another column text value if the conditions are met: Crediteur =IF(&nbsp; &nbsp; &nbsp; &nbsp; [Autorisatie_fact] = 1,&nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE(FACT_Realisatie[Crediteur]),&nbsp; &nbsp; &nbsp; &nbsp; "***"&nbsp; &nbsp; )This works fine but, now i want also to be able to summarize the text values output in order to aggregate the rows with other measures sum average etc...it needs to be done in measures in order to make the filter context apply.&nbsp;I have spend a week talking to chat gpt but still no working result.&nbsp;&nbsp;It should be something like:&nbsp;crediteurconditionbedragA110B120A110C010&nbsp;CrediteurBedrag&nbsp;A20&nbsp;B20&nbsp;&nbsp;

anonymous · Accepted Answer

Hi&nbsp;jimod&nbsp;,
&nbsp;
(1)Here are my test data.

(2) We can create a new table.
Table 2 = FILTER(SUMMARIZE('Table',[Rediteur],"bedrag",SUM('Table'[bedrag])),[Rediteur] in {"A","B"})
(3)&nbsp;Then the result is as follows.

&nbsp;
If this doesn't help you, give examples of input and output data and explain your logic.&nbsp;Preferably a PBIX file (take care to protect your private data)
&nbsp;
Best Regards,
Neeko Tang
If this post &nbsp;helps, then please consider Accept it as the solution&nbsp; to help the other members find it more quickly.&nbsp;

Forum Discussion

Difficulty with measures

1 Reply

Related content

Measure Difficulties

Authenticating OData.Feed using Web API difficulty

POWERBI LOGIN DIFFICULTY

Difficulty with formulas

Difficulties connecting Oracle SQL Developer to Power BI

crediteur	condition	bedrag
A	1	10
B	1	20
A	1	10
C	0	10

Crediteur	Bedrag
A	20
B	20