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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
husfghk11
Frequent Visitor

Do not sum ratio

I want to build a matrix table like this:

RegionRatioSales 2021Sales 2022
Asia 13,29013,431
  Central Asia 600260
    Kazakhstan0.0510020
    Kyrgyzstan0.02300100
    Turkmenistan0.210050
    Uzbekistan0.210090
  East Asia 11,05011,495
    China0.455,5005,700
    Japan0.33,0003,200
    South Korea0.12,5002,550
    Mongolia0.025045
  South East Asia 1,6401,676
    Malaysia0.2250225
    Indonesia0.31300310
    Singapore0.41,0001,050
    Philippines0.234040
    Vietnam0.115051

 

What should I do if I do not want to aggregate the ratio at a higher level / group level as per the table above? These ratio shouldn't be summed as they are standalone ratio.

2 REPLIES 2
Greg_Deckler
Super User
Super User

@husfghk11 Are those measures? If they are then you shouldn't have to worry about that. If they are a column then you should just have to choose the "Do not aggregrate" option.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Hi @Greg_Deckler 

 

The ratio, sales 2021 and sales 2022 are all measures. When i put the ratio in, it will sum up automatically at each level (e.g. Asia, Central Asia etc.). The ratio should only be summed up at country level only but not level higher than country. The result that I wish is blank for ratio at Asia and Central Asia level.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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