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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
HpDp
New Member

how add columns or create new table from different two tables power bi without relationship

HpDp_0-1735201103725.png

Hello Everyone,

hope you all in good spirit. 

Well , I am stuck in above situation. Can some help me or support me in creating another table C as explained above based on slicer  selected value. At present Slicer value selected is null or default value .

 

HpDp_1-1735201835254.png

 

2 ACCEPTED SOLUTIONS
v-ssriganesh
Community Support
Community Support

Hi @HpDp 
Thank you for posting your query in the Microsoft Fabric community.

Calculated tables have fixed data structures and do not adjust with filter changes. Using measures provides a flexible and responsive report that reflects real-time changes based on user selections. Instead of creating a calculated column in Table C that directly depends on the slicer's selection, I have implemented two measures that dynamically compute values based on the slicer selection.

Measure 1:
Selected_Discount = SELECTEDVALUE('Table B'[DISCOUNT_PERCENT], 0)

Measure 2:
Adjusted_Value =  

SUMX( 

    'Table A', 

    'Table A'[VALUE] * (1 - [Selected_Discount]/100) 

)

Created a Table Visual:

  • Bring in ITEM CODE from Table A.
  • For "Selected Discount," instead of showing it directly, you can use the measure - Selected_Discount.
  • For adjusted value, use the measure - Adjusted_Value

Use the slicer to select different discount percentages. The Selected_Discount measure will update accordingly, and the Adjusted_Value should accurately reflect the adjusted values from Table A. Please refer to the screenshot below, and I have attached the pbix file for your reference.

vssriganesh_0-1735215565510.png

If this helps then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Hope this works for you!
Thanks.

View solution in original post

HpDp
New Member

Thank You So much. Thats fantastic... I did not thought in this direction. Great.

View solution in original post

2 REPLIES 2
HpDp
New Member

Thank You So much. Thats fantastic... I did not thought in this direction. Great.

v-ssriganesh
Community Support
Community Support

Hi @HpDp 
Thank you for posting your query in the Microsoft Fabric community.

Calculated tables have fixed data structures and do not adjust with filter changes. Using measures provides a flexible and responsive report that reflects real-time changes based on user selections. Instead of creating a calculated column in Table C that directly depends on the slicer's selection, I have implemented two measures that dynamically compute values based on the slicer selection.

Measure 1:
Selected_Discount = SELECTEDVALUE('Table B'[DISCOUNT_PERCENT], 0)

Measure 2:
Adjusted_Value =  

SUMX( 

    'Table A', 

    'Table A'[VALUE] * (1 - [Selected_Discount]/100) 

)

Created a Table Visual:

  • Bring in ITEM CODE from Table A.
  • For "Selected Discount," instead of showing it directly, you can use the measure - Selected_Discount.
  • For adjusted value, use the measure - Adjusted_Value

Use the slicer to select different discount percentages. The Selected_Discount measure will update accordingly, and the Adjusted_Value should accurately reflect the adjusted values from Table A. Please refer to the screenshot below, and I have attached the pbix file for your reference.

vssriganesh_0-1735215565510.png

If this helps then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Hope this works for you!
Thanks.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.