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
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
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.