Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filter table before using CROSSJOIN

Hi,   I want to create a crossjoin table of the table below with only "A" values in the "field" column. I know how to do this if I first manually filter the field. However, this is not a suitable o...
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , what is the expected output table, is not very clear. Please share an example

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandak 

     

    Here's the expected output table. In this example I have filtered "field" A in query editor before creating the new table using crossjoin. My goal is to find a way to keep the original table untouched and do the "field" filtration in dax when creating the new crossjoined table.