Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Shameem
New Member

Displaying two Fields data into same table.

We have a requirement where we have two Product fields. One is Product (single select), other field is 'Local Product(Multi select)'.

 

Product and local product are not associated in symantic model. 

 

Requirment is to when one value of Product filed selected and some values in local product are selected both the selections should be displayed with thier respective volumes into the table .

 

Eg: Product : Car;  Local Product : Bike , Bus

Result : 

ProductVolume
Car

200

Bike 500
Bus100
1 ACCEPTED SOLUTION

4 REPLIES 4
Shameem
New Member

Hello @tamerj1 , Thank you for reply, I have same values in both Product and local product field. And one is single select and other is multi select respectively, as in UI same screen contains  few metrics which are depending on single select field and few metrics depend on both . Below is the case.

Shameem_0-1713875648828.pngShameem_1-1713875871012.png

 

Thank you for the solution.

tamerj1
Super User
Super User

Hi @Shameem 
Please refer to attached sample file with the proposed solution

1.png2.png

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.