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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
H_Fred
New Member

data on the basis of a variable

 

Hi I'm new here,
And I have a question about querying data in Power BI
I want to select an item from a range of receipts. This article can appear in several coupons.
I want a list of all articles in which this article appears. can I fix that with DAX

2 REPLIES 2
H_Fred
New Member

Good evening, I have fed a data set. of this set I would like to show the whole set of a [TRANSACTIENR] all [ARTIKELNUMMER]. ARTIKELNUMMER = 120590

you will then see all the articles that appear in a set containing nr 120590 onle set 209

VESTIGINGDATUMTRANSACTIENRARTIKELNUMMEROMSCHRIJVING_LAANTAL
506130-jan-21207258116TINTELFRUIT APPEL CRANBERRY        1
506130-jan-21207661190IJSCUPS BRUIN                      1
506130-jan-21207451160BONI BROODJE                       1
506130-jan-21207257748HOUDBARE VOLLE MELK                1
506130-jan-21207257748HOUDBARE VOLLE MELK                1
506130-jan-21207451394TIJGERBOLLEN                       1
506130-jan-21207201685VANILLE IJS                        1
506130-jan-21207289697TORTILLA CHIPS NACHO CHEESE        1
506130-jan-21207293601PISTACHENOTEN GEZOUTEN             1
506130-jan-21207294258VANILLE VLA                        1
506130-jan-21207289698TORTILLA CHIPS NATUREL             1
506130-jan-21207289888RONDOS                             1
506130-jan-21207217971STUDENTENHAVER                     1
506130-jan-21207310484BORREL BITES PAPRIKASWEET          1
506130-jan-21207293870CHOCOLADE PINDAS                   1
506130-jan-21207258115TINTELFRUIT APPEL BOSVRUCHTEN      1
506130-jan-21207296902SPELT BROODJE                      1
506130-jan-21207914515KIP SHOARMA                        1
506130-jan-21208210083ICETEA PERZIK                      1
506130-jan-21208258132ZAPPIE TROPISCH                    1
506130-jan-21208408933BIG CITY PIZZA ROME                1
506130-jan-21208408933BIG CITY PIZZA ROME                1
506130-jan-21208408933BIG CITY PIZZA ROME                1
506130-jan-21208219062RAVIOLI BOLOGNESE                  1
506130-jan-21208219062RAVIOLI BOLOGNESE                  1
506130-jan-21208404446KROKETTEN RUNDVLEES                1
506130-jan-21208403712HAMBURGERS                         1
506130-jan-21208710322TOMAAT SNOEP SHAKER                1
506130-jan-21209292070MELOEN WATER                       1
506130-jan-21209228922KROEPOEK BALI                      1
506130-jan-21209711170EIKENBLADSLA MELANGE               1
506130-jan-21209257725KAISERBROODJES                     1
506130-jan-21209257725KAISERBROODJES                     1
506130-jan-21209210481FRAMBOZEN                          1
506130-jan-21209222770AARDBEIEN                          1
506130-jan-21209104120SLA                                1
506130-jan-21209104120SLA                                1
506130-jan-21209120590BANANEN                            1
506130-jan-21209294319WRAPHAPJES MET ZALM                1
506130-jan-21209296426MINI GRILLWORST KAAS               1
506130-jan-21209294315SERRANO ROOMKAAS ROLLETJES         1
506130-jan-21209228915KETJAP MANIS ZOET                  1
506130-jan-21209990062SCHWARZWALDER SCHINKEN             1
506130-jan-21209990084GEGRILDE HAM                       1
506130-jan-21209499974RUNDERHACHEE                       1
506130-jan-21209296450ZAK ELSTAR                         1
506130-jan-21209200635ROOMBOTER ONGEZOUTEN               1
506130-jan-21209293838PAASEITJES MIX DOOSJE              1
506130-jan-21209297218SPECKLED EGGS                      1
506130-jan-21209219510KOMKOMMER                          1
506130-jan-21209219510KOMKOMMER                          1
506130-jan-21209296542ROOMBOTER GEZOUTEN                 1
506130-jan-21209600570FRAMBOOSCRANBERRY                  1
506130-jan-21209121450WITLOF                             1
506130-jan-21209915535KAAS-GEHAKT STICK 4 ST             1
506130-jan-21209249810HALFVOLLE MELK                     1
506130-jan-21209400639BOERENYOGHURT HALFVOL              1
506130-jan-21209225774ZEEZOUT FIJN                       1
506130-jan-21211297704WASMIDDEL KLEUR 40SC               1
506130-jan-21211407072KRUIDENKAAS                        1
506130-jan-21211263694MINI KLUIVEN                       1
506130-jan-21211263695MERGKOEKJES                        1
506130-jan-21211604821RIESLING QBA                       1
506130-jan-21211604821RIESLING QBA                       1
506130-jan-21211208443HALFVOLLE MELK                     1
506130-jan-21211408383BELEGEN KOMIJN GSN                 1

 

 

 

mahoneypat
Employee
Employee

That is doable.  Please share example data (not as an image so we can copy/paste it), to get a specific expression.

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors