Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Jeni2608
Frequent Visitor

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

‎02-16-2023 08:20 PM

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.

 

Jeni2608_0-1676607425430.png

 

.

 

Labels:
Message 1 of 3
389 Views
0
2 REPLIES 2
MFelix
Super User
Super User

‎02-17-2023 04:28 AM

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?


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Message 2 of 3
333 Views
0
Jeni2608
Frequent Visitor
In response to MFelix

‎02-17-2023 09:19 AM

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

Message 3 of 3
318 Views
0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

View All