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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
KH_Mike
Helper III
Helper III

How to use the same column to calculate two dimension

Hi All,

 

I have a data like below and want to have two separate measure to calculate and put it into a scatter chart X & Y axis. I tried to create new column by using existing "Type" column. and Make the "Type" and "New Type" as a slicer. Then set both slicer not filter together. However, when I try to create two measure like below but seems it will affected by the "Type" and "New Type" selection.

 

X Axis = calculate(sum([Amount]),removefilters([New Type]))

Y Axis = calculate(sum([Amount]),removefilters([Type]))

 

TypeAmount
A10
A20
B30
B40
C50
C60
D70
D80
E90
E100
1 ACCEPTED SOLUTION
v-xiaotang
Community Support
Community Support

Hi @KH_Mike 

Thanks for reaching out to us.

>> Then set both slicer not filter together.

First you need to create 2 dimension tables, 'X Axis' & 'Y Axis'.

then please go to Model view, make sure these 3 tables are independent from each other,

vxiaotang_1-1662618517704.png

then create 2 measures,

X Axis = calculate(sum('Table'[Amount]),FILTER('Table','Table'[Type] in ALLSELECTED('X Axis'[Type])))
Y Axis = calculate(sum('Table'[Amount]),FILTER('Table','Table'[Type] in ALLSELECTED('Y Axis'[Type])))

result

vxiaotang_3-1662618682732.png

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-xiaotang
Community Support
Community Support

Hi @KH_Mike 

Thanks for reaching out to us.

>> Then set both slicer not filter together.

First you need to create 2 dimension tables, 'X Axis' & 'Y Axis'.

then please go to Model view, make sure these 3 tables are independent from each other,

vxiaotang_1-1662618517704.png

then create 2 measures,

X Axis = calculate(sum('Table'[Amount]),FILTER('Table','Table'[Type] in ALLSELECTED('X Axis'[Type])))
Y Axis = calculate(sum('Table'[Amount]),FILTER('Table','Table'[Type] in ALLSELECTED('Y Axis'[Type])))

result

vxiaotang_3-1662618682732.png

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@KH_Mike , You need at least one independent table

Type new = distinct(Table[Type])

 

Then you need have a measure

Calculate(sum([Amount]),removefilters([Type]), keepfilters(Type[Type]))

 

or

 

Calculate(sum([Amount]),Filter(all(Table[Type]), Table[Type]) in values(Type[Type])) )

 

Also refer

Need of an Independent Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE

Compare two Brands: https://youtu.be/exN4nTewgbc

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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