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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
bidata
New Member

Add total groups from Table 1 as new column to Table 2

Hello,

 

I am trying to add a new column into Table2 as I show below in DAX:

 

Table1   
oficegroupstatusvalue
adz1
ady0
afz2
afy2
bgz0
bgy2
bhz1
bhy1
adz0
ady1
afz4
afy1
bgz3
bgy3
bhz1
bhy5

 

Table2    
DATEoficegroupvalue 
01/01/2022ad11+0
01/01/2022af42+2
01/01/2022bg20+2
01/01/2022bh21+1
02/01/2022ad10+1
02/01/2022af54+1
02/01/2022bg63+3
02/01/2022bh61+5

 

And then i need to be able to filter by multiple items by Status from table1.

Thank you in advance! 

 

1 ACCEPTED SOLUTION
v-chenwuz-msft
Community Support
Community Support

Hi @bidata ,

 

A little confused, is that Table2 a visualiztion?

If yes, just need to put the value from Table1 into the table visual.

vchenwuzmsft_0-1659685077561.gif

Pbix in the end you can refer.

 

If Table2 is a fact table, you can not change the total value by filter the status from Table1.

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

View solution in original post

1 REPLY 1
v-chenwuz-msft
Community Support
Community Support

Hi @bidata ,

 

A little confused, is that Table2 a visualiztion?

If yes, just need to put the value from Table1 into the table visual.

vchenwuzmsft_0-1659685077561.gif

Pbix in the end you can refer.

 

If Table2 is a fact table, you can not change the total value by filter the status from Table1.

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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