cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RedGC
Frequent Visitor

calculate a measure through different tables

Hi Folks,
I have the following model and would like to calculate total sales for the the selected Value of "Value" field inside "Dimension Slicer 2". 

 

RedGC_0-1620758188001.png

 

someone has an idea how to do it please. Thanks alot for your help and effort folks.

 

 

 

2 REPLIES 2
v-easonf-msft
Community Support
Community Support

Hi,  @RedGC 

I'm curious why you created three calculated tables (A/B/C)?

Please explain it in more details.Sample data/pbix file and expected result will better help us understand this problem.

Does the following formula not work?

suma =
CALCULATE ( SUM ( 'salesamount'[sales_amount] ) )

 

Best Regards,
Community Support Team _ Eason

RedGC
Frequent Visitor

Hi @Jihwan_Kim
I hope you're doing well !. 
Do you have any idea how to solve this issue ?
Thanks alot for your response and your efforts.
have a good day. 

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors