Forum Discussion

HpDp's avatar
HpDp
New Member
1 year ago
Solved

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

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 .

 

 

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

    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.

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

2 Replies

  • HpDp's avatar
    HpDp
    New Member

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

  • v-ssriganesh's avatar
    v-ssriganesh
    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.

    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.