Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Help: Select colums with some condition

 
Hello!!
Im new in PBI, and  I want to calculate in dax a column that tells me when the same provider sells groups of different materials. The information is filtered by country. I do not know how to create this, if it should be in a dax function, or a query.
Thank you very much for your help
Mónica
 
Need Help

2 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

    Would you please clarify the condition about “same provider sells groups of different materials”? From your sample data, which column represents provider values? Which logic do you use to get the expected results based on sample data?

     

    Regards,

    Daniel He

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks for you reply.

       

      From the sample data,

      The column of Supplier when the supplier sells diferents materials in one country, for example... supplier 20 sells materials ABC and DEF in USA, I want show only this information in a table. 

      Im dont not how to do this in DAX, o maybe is better do it in Edith query?

       

      Thanks for the help.

      Mónica