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
Anonymous
Not applicable

Creating an Indexed Measure While using SSAS direct connect

This may be something we need to create in the cube but i was looking for a way to create an indexed measure for a dimension table so that i can visualize 'outliers'.

 

An example of this would be:

 

Item A accounts for 20% of sales and 20% of revenue so its index of revenue would be 100.

Item B accounts for another 20% of sales but 40% of revenue so would index as 200 on revenue.

 

The calculation i am looking to recreate in DAX would be:

 

((Sum(SalesCount)/sum(TOTAL SalesCount)) / (sum(Revenue)/sum(TOTAL Revenue))) * 100

 

where TOTAL is overall total with no selections made.

 

I should then be able to create a table listing items as a dimension and then the index value as a measure to allow me to quickly identify where revenue is coming from compared to actual sales volume/qty for each of the items.

 

Thanks

 

 

 

0 REPLIES 0

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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.