Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter the calculated table

Hi everyone,   I have DAX problem. I'm tring to return only those rows from TABLE1 which have value in [Attribute] column is equal to TABLE2[name] value and TABLE1[project]  = TABLE2[project].   ...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

create a new column in table like

New column in Table 1 = maxx(filter(table2,table1[Attribute] = table2[name] && table1[project] = table2[project],table[name])

 

The rows you need is the one that has value

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    amitchandak thank you for your answer ! It's working. But maybe you have idea how to put your formula:

     

     maxx(filter(table2,table1[Attribute] = table2[name] && table1[project] = table2[project],table[name])

     

    into my script which create new table (below I put simplified script, the orginal script have unions ect.):

     

    Attributes =

    VAR All_attributes =
    SELECTCOLUMNS (
    'TABLE1';
    "casx_id"; TABLE1[id];
    "Attribute"; TABLE1[name];
    "project"; TABLE1[project];)

    RETURN
    All_attributes