Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

DAX Formulas

Hi Guys   I am trying to create a calculated column based on a number of different dependancies; In order to determine if an opportunity requires a Concept of System document, the opportunity need...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Anonymous,

     

    Based on current description, it's hard to imagine your data structure and provide detailed advice. To apply filters with a mix of AND + OR statements, you can create DAX formula similar to:

    Measure=CALCULATE(expression1,FILTER(table, Filter1&&(Filter2||Filter3)))

     

    For more advice, please provide sample data and show us desired output. How to Get Your Question Answered Quickly

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

Based on current description, it's hard to imagine your data structure and provide detailed advice. To apply filters with a mix of AND + OR statements, you can create DAX formula similar to:

Measure=CALCULATE(expression1,FILTER(table, Filter1&&(Filter2||Filter3)))

 

For more advice, please provide sample data and show us desired output. How to Get Your Question Answered Quickly

 

Best regards,

Yuliana Gu