Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 .
Solved! Go to Solution.
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:
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.
Thank You So much. Thats fantastic... I did not thought in this direction. Great.
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:
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.