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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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
Microsoft Employee
Microsoft 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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.