Forum Discussion

Jeni2608's avatar
Jeni2608
Frequent Visitor
3 years ago

create power BI report using nested AND , OR filter conditions across different dimensions

Hi, 

i need to create a power BI report with 20 columns from dimensions and 6 columns from 2 fact tables, it is a multi fact start schema model, 2 fact tables are joined with all confiormed dimensions.

 

how to apply the below filter.

 

 

.

 

Need Help

2 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    3 years ago

    Hi Jeni2608 ,

     

    What do you mean create a report using this conditions? are you refering to SQL or to a measure that you need to create? Is it the way the dimensions work within the relationships?

    • Jeni2608's avatar
      Jeni2608
      Frequent Visitor
      3 years ago

      Yes create report with these conditions. i want measures to use them as drag and drop to show the data for these applied filters.