Forum Discussion

jimod's avatar
jimod
Regular Visitor
2 years ago
Solved

Difficulty with measures

  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 (         COUNTROWS (             FILTE...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi jimod ,

     

    (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) Then the result is as follows.

     

    If this doesn't help you, give examples of input and output data and explain your logic. Preferably a PBIX file (take care to protect your private data)

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi jimod ,

 

(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) Then the result is as follows.

 

If this doesn't help you, give examples of input and output data and explain your logic. Preferably a PBIX file (take care to protect your private data)

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.