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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
aerizk
Helper I
Helper I

Calculate measure at aggregated level only

I have two tables with similar granularities and i want to calculate a simple KPI that divides one measure by another in the second table. the two tables are linked together by country, business type dimension, and date dimension. The KPI is simply dividing the total Sales of the first by the total Vol for each month. However i want this measure to always be done at country level and does not change if I select shop or store from the customer type dimension.

 

DateBusinessTypeCountrySales
01/01/2023ShopES100.00
02/01/2023ShopES200.00
03/01/2023ShopES300.00
01/01/2023ShopES500.00
02/01/2023ShopES600.00
03/01/2023ShopES700.00

 

DateBusinessTypeCountryVol
01/01/2023StoreES1000
02/01/2023StoreES1200
03/01/2023StoreES1300
01/01/2023StoreES1000
02/01/2023StoreES1200
03/01/2023StoreES1300

 

When I test in a table my table looks like this, which is correct at total. But I want this measure to be impacted no matter what i select in Business Type

 

DateBusinessTypeSalesVolPercentage
01/01/2023Shop600.00 0
01/01/2023Store 2,000.00 
Total 600.002,000.0030%

 

However when I select a Business Type from the slicer as Shop for example this is what I see.

DateBusinessTypeSalesVolPercentage
01/01/2023Shop600.00 0
Total   0%

 

Thank you!

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

1 REPLY 1
lbendlin
Super User
Super User

lbendlin_0-1696098425253.png

 

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.