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: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
V2jtb-Info
New Member

Measure to list columns from two slices

‎04-29-2023 06:50 AM

Hi All,

I am using Power Bi for the first time and spent weeks trying to understand (Learn small steps) a simple Excel file that I produce ever month, highlighting the differences in three columns.

I take the spreadsheet and combine each of the month Tabs into one sheet with Power Bi and call the first column the Report date.

I then create three reference tables with the report date App_Key (that I made) and pivot the three tables by the Report date this gives me comparison layout.  This took me about 6 weeks to get to this stage.

I have two slicers with two separate tables with the Report Date (Table A and Table B)

Table A

Selection Value A = IF(SELECTEDVALUE('Table A'[Report Date])

=SELECTEDVALUE('Table B'[Report Date]),0,1)

 

Table B

Selection Value B = IF(SELECTEDVALUE('Table B'[Report Date])

=SELECTEDVALUE('Table A'[Report Date]),0,1)

 

So this bit works on the selection.

 

My issue is that I want to filter and display the columns from the selection

 

Measure A Table = VALUES(Data[Report Date]),FILTER(Data,Data[Report Date]=SELECTEDVALUE('Table A'[Report Date]))

 

But not understanding Dax and I can’t see what is wrong

Labels:
Message 1 of 5
484 Views
0
4 REPLIES 4
selimovd
Super User
Super User

‎04-29-2023 08:23 AM

Hey  @V2jtb-Info ,

 

as always the start is difficult, but it will get easier over time.

Your description is very hard to understand as we all don't know your data model.

 

Can you create a sample file and share it here? This would make it a lot easier to help you.

 

Best regards

Denis

Message 2 of 5
435 Views
0
V2jtb
New Member
In response to selimovd

‎04-30-2023 02:55 AM
Report Dateu business _ applicationu business applicationsys updated_on1 business applicationsys updated byu _ business _ applicationbusiness _ criticalityu business _ applicationinternal lifecyclesys _created_onsys created _bysys_ updated_onsys_updated_byu _ business _ applicationu_ deployment_modeservice _provideru typeu_provideru business applicationit _owneru _ business applicationu it teamu _ business applicationu bu manageru _ business _ applicationu system_ownru business _ applicationstewardu _ business _ applicationu_ifc relevancebusiness applicationu solvency_ ii relevance1 business applicationu sensitive _data_y_nu business applicationu aaa_ tech cloud _brokeru _ business _ applicationcomments
31-Jan-22Wordpad10/12/2021 15:20Tracy@jtboyle.co.ukImportantLive10/12/2021 15:20mail@jtboyle.co.uk18/10/2021 00:09mail@jtboyle.co.ukOn PremiseNot SuppliedTraditional InfrastructureABCDarcy SoperSales Department John JenniferBlake RobinsonJorge WhiteYesNot SuppliedNot SuppliedTRUENot Supplied
08-Mar-23Wordpad10/12/2021 15:20Tracy@jtboyle.co.ukImportantLive10/12/2021 15:20mail@jtboyle.co.uk18/10/2021 00:09mail@jtboyle.co.ukOn PremiseNot SuppliedTraditional InfrastructureABCDarcy SoperSales Department John JenniferBlake RobinsonJorge WhiteYesNot SuppliedNot SuppliedTRUENot Supplied
05-Apr-23Wordpad10/12/2021 15:20Tracy@jtboyle.co.ukImportantLive10/12/2021 15:20mail@jtboyle.co.uk18/10/2021 00:09mail@jtboyle.co.ukOn PremiseNot SuppliedTraditional InfrastructureABCDarcy SoperSales Department John JenniferBlake RobinsonJorge WhiteYesNot SuppliedNot SuppliedTRUENot Supplied
12-Apr-23Wordpad10/12/2021 15:20Tracy@jtboyle.co.ukImportantLive10/12/2021 15:20mail@jtboyle.co.uk18/10/2021 00:09mail@jtboyle.co.ukOn PremiseNot SuppliedTraditional InfrastructureABCDarcy SoperSales Department John JenniferBlake RobinsonJorge WhiteYesNot SuppliedNot SuppliedTRUENot Supplied
31-Jan-22Word18/10/2021 00:09mail@jtboyle.co.ukNot SuppliedProposition18/10/2021 00:09Tracy@jtboyle.co.uk10/12/2021 15:20Tracy@jtboyle.co.ukPaaSMicrosoftPublic PaaSMS AzureTracy WhiteHuman Resource Department William BarbaraRiley DavisRoberto WilliamsYesYesYesTRUENot Supplied
08-Mar-23Word18/10/2021 00:09mail@jtboyle.co.ukNot SuppliedProposition18/10/2021 00:09Tracy@jtboyle.co.uk10/12/2021 15:20Tracy@jtboyle.co.ukPaaSMicrosoftPublic PaaSMS AzureTracy WhiteHuman Resource Department William BarbaraRiley DavisRoberto WilliamsYesYesYesTRUENot Supplied
05-Apr-23Word18/10/2021 00:09mail@jtboyle.co.ukNot SuppliedProposition18/10/2021 00:09Tracy@jtboyle.co.uk10/12/2021 15:20Tracy@jtboyle.co.ukPaaSMicrosoftPublic PaaSMS AzureTracy WhiteHuman Resource Department William BarbaraRiley DavisRoberto WilliamsYesYesYesTRUENot Supplied
12-Apr-23Word18/10/2021 00:09mail@jtboyle.co.ukNot SuppliedProposition18/10/2021 00:09Tracy@jtboyle.co.uk10/12/2021 15:20Tracy@jtboyle.co.ukPaaSMicrosoftPublic PaaSMS AzureTracy WhiteHuman Resource Department William BarbaraRiley DavisRoberto WilliamsYesYesYesTRUENot Supplied
31-Jan-22Windows Movie Maker18/10/2021 00:09Tracy@jtboyle.co.ukImportantLive18/10/2021 00:09mail@jtboyle.co.uk10/12/2021 15:20mail@jtboyle.co.ukPaaSMicrosoftPublic PaaSMS AzureDarcy SoperSales Department Steven KimberlyLewis MartinGilbert WalkerNoNoUnkownTRUENot Supplied
08-Mar-23Windows Movie Maker18/10/2021 00:09Tracy@jtboyle.co.ukImportantLive18/10/2021 00:09mail@jtboyle.co.uk10/12/2021 15:20mail@jtboyle.co.ukPaaSMicrosoftPublic PaaSMS AzureDarcy SoperSales Department Steven KimberlyLewis MartinGilbert WalkerNoNoUnkownTRUENot Supplied
05-Apr-23Windows Movie Maker18/10/2021 00:09Tracy@jtboyle.co.ukImportantLive18/10/2021 00:09mail@jtboyle.co.uk10/12/2021 15:20mail@jtboyle.co.ukPaaSMicrosoftPublic PaaSMS AzureDarcy SoperSales Department Steven KimberlyLewis MartinGilbert WalkerNoNoUnkownTRUENot Supplied
12-Apr-23Windows Movie Maker18/10/2021 00:09Tracy@jtboyle.co.ukImportantLive18/10/2021 00:09mail@jtboyle.co.uk10/12/2021 15:20mail@jtboyle.co.ukPaaSMicrosoftPublic PaaSMS AzureDarcy SoperSales Department Steven KimberlyLewis MartinGilbert WalkerNoNoUnkownTRUENot Supplied
31-Jan-22VLC10/12/2021 15:20mail@jtboyle.co.ukMission CriticalLive10/12/2021 15:20mail@jtboyle.co.uk18/10/2021 00:09mail@jtboyle.co.uklaaSNot SuppliedlaaSOtherJohn BoylePurchase DepartmentMatthew BettyMiles KingJorge WhiteNot SuppliedNot SuppliedNot SuppliedTRUENot Supplied
08-Mar-23VLC10/12/2021 15:20mail@jtboyle.co.ukMission CriticalLive10/12/2021 15:20mail@jtboyle.co.uk18/10/2021 00:09mail@jtboyle.co.uklaaSNot SuppliedlaaSOtherJohn BoylePurchase DepartmentMatthew BettyMiles KingJorge WhiteNot SuppliedNot SuppliedNot SuppliedTRUENot Supplied
05-Apr-23VLC10/12/2021 15:20mail@jtboyle.co.ukMission CriticalLive10/12/2021 15:20mail@jtboyle.co.uk18/10/2021 00:09mail@jtboyle.co.uklaaSNot SuppliedlaaSOtherJohn BoylePurchase DepartmentMatthew BettyMiles KingJorge WhiteNot SuppliedNot SuppliedNot SuppliedTRUENot Supplied
12-Apr-23VLC10/12/2021 15:20mail@jtboyle.co.ukMission CriticalLive10/12/2021 15:20mail@jtboyle.co.uk18/10/2021 00:09mail@jtboyle.co.uklaaSNot SuppliedlaaSOtherJohn BoylePurchase DepartmentMatthew BettyMiles KingJorge WhiteNot SuppliedNot SuppliedNot SuppliedTRUENot Supplied
31-Jan-22Visio10/12/2021 15:20mail@jtboyle.co.ukMission CriticalIn Development10/12/2021 15:20Tracy@jtboyle.co.uk18/10/2021 00:09Tracy@jtboyle.co.ukSaaSNot SuppliedSaaSFGH Neels BrownFinance Department Michael LindaSeth BrownDan WilsonYesYesYesTRUENot Supplied
08-Mar-23Visio10/12/2021 15:20mail@jtboyle.co.ukMission CriticalIn Development10/12/2021 15:20Tracy@jtboyle.co.uk18/10/2021 00:09Tracy@jtboyle.co.ukSaaSNot SuppliedSaaSFGH Neels BrownFinance Department Michael LindaSeth BrownDan WilsonYesYesYesTRUENot Supplied
05-Apr-23Visio10/12/2021 15:20mail@jtboyle.co.ukMission CriticalIn Development10/12/2021 15:20Tracy@jtboyle.co.uk18/10/2021 00:09Tracy@jtboyle.co.ukSaaSNot SuppliedSaaSFGH Neels BrownFinance Department Michael LindaSeth BrownDan WilsonYesYesYesTRUENot Supplied
12-Apr-23Visio10/12/2021 15:20mail@jtboyle.co.ukMission CriticalIn Development10/12/2021 15:20Tracy@jtboyle.co.uk18/10/2021 00:09Tracy@jtboyle.co.ukSaaSNot SuppliedSaaSFGH Neels BrownFinance Department Michael LindaSeth BrownDan WilsonYesYesYesTRUENot Supplied
31-Jan-22The Applicaion can have duplicate entries18/10/2021 00:09mail@jtboyle.co.ukImportantNot Supplied18/10/2021 00:09Tracy@jtboyle.co.uk18/10/2021 00:09Tracy@jtboyle.co.ukPaaSMicrosoftPublic PaaSMS AzureDarcy SoperSales Department David ElizabethIvan ClarkBrian YoungYesYesUnkownTRUENot Supplied
08-Mar-23The Applicaion can have duplicate entries18/10/2021 00:09mail@jtboyle.co.ukImportantNot Supplied18/10/2021 00:09Tracy@jtboyle.co.uk18/10/2021 00:09Tracy@jtboyle.co.ukPaaSMicrosoftPublic PaaSMS AzureDarcy SoperSales Department David ElizabethIvan ClarkBrian YoungYesYesUnkownTRUENot Supplied
05-Apr-23The Applicaion can have duplicate entries18/10/2021 00:09mail@jtboyle.co.ukImportantNot Supplied18/10/2021 00:09Tracy@jtboyle.co.uk18/10/2021 00:09Tracy@jtboyle.co.ukPaaSMicrosoftPublic PaaSMS AzureDarcy SoperSales Department David ElizabethIvan ClarkBrian YoungYesYesUnkownTRUENot Supplied
12-Apr-23The Applicaion can have duplicate entries18/10/2021 00:09mail@jtboyle.co.ukImportantNot Supplied18/10/2021 00:09Tracy@jtboyle.co.uk18/10/2021 00:09Tracy@jtboyle.co.ukPaaSMicrosoftPublic PaaSMS AzureDarcy SoperSales Department David ElizabethIvan ClarkBrian YoungYesYesUnkownTRUENot Supplied
Message 5 of 5
406 Views
0
V2jtb
New Member
In response to selimovd

‎04-30-2023 02:51 AM

Screenshot 2023-04-30 103201.png

Message 3 of 5
407 Views
0
V2jtb
New Member
In response to V2jtb

‎04-30-2023 03:10 AM
Column NameComment
App_Keyis concatenation of u business _ application and u type
Report Date 
u business _ application 
u business applications updated_on 
1 business applicationsys updated by 
u _ business _ applicationbusiness _ criticality1 monitoring for change
u business _ applicationinternal lifecycle2 monitoring for change
sys _created_on 
sys created _by 
sys_ updated_on 
sys_updated_by 
u _ business _ applicationu_ deployment_mode3 monitoring for change
service _provider 
u type 
u_provider 
u business applicationit _ownerwhen a change is fond on 1,2 or 3
u _ business applicationu it teamwhen a change is fond on 1,2 or 3
u _ business applicationu bu managerwhen a change is fond on 1,2 or 3
u _ business _ applicationu system_ownrwhen a change is fond on 1,2 or 3
u business _ applicationstewardwhen a change is fond on 1,2 or 3
u _ business _ applicationu_ifc relevance 
business applicationu solvency_ ii relevance 
1 business applicationu sensitive _data_y_n 
u business applicationu aaa_ tech cloud _broker 
u _ business _ applicationcomments 
Message 4 of 5
404 Views
0

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

View All