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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
souvik900766
Helper IV
Helper IV

Base of measure changing

Hi !
I want my base across cells to be same like this but when I am trying to sort the category column with a index i am getting a circular dependency.
The measure I have used =

02_Increment Growth Driver table Base = CALCULATE([08_Increment],ALL('New Category Sort Table'[ctgry_nm]),ALL(Country[ctry_nm]))

 

 

correct.PNG

ct.png

 

So, I made another Category table and brought the category and the numbers are coming correct

 

New table comes ok.PNG

 

but when I am sorting the new table with a Index column my numbers are changing column wise !

 

changes.PNG

 

My data Model:-

First (Pic) Category comes from this category Net Dimension Table
Sencond and Third (Pic) Category comes from category Net table.
In rows I have Country that also comes from a dimension table.

 

dm.PNG


Kindly guide me what to do.
Thanks in Advance !

1 REPLY 1
Anonymous
Not applicable

Hello @souvik900766 
Can you please share the sample data after removing the sensitive information?

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.