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
CracktheCode85
Helper II
Helper II

SSAS Cube Data Impot Mode Issues

Hi Experts! 

I'm working with an SSAS Cube data connection building a dashboard in BI. It has multiple calculated fields that when connected to the dashboard as a "Live Connection" work perfectly- but I am unable to customize anything: No measures, columns, title cards, even decimal places cannot be changed. 

So I used the Import method and chose the fields I need. The issue I'm currently running into is:
Day Sales Outstanding is a calculated field that when imported SUMs up to horribly wrong amounts, and the closest I've gotten to the right figures are using the Average function for the DSO field but it's still really off. 

When I try to create my own measure for Current and Previous DSO it works great! 
But when I try to add parameters like "Accrual DSO" = Calculate('DSO_Table[DSO_Measure], Filter(DSO_Table, [X] in {"Parameter", "Parameter_2"}))
and so forth....
I get blank results. 

I'm not sure how to fix this issue if anyone can please provide guidance!

2 REPLIES 2
lbendlin
Super User
Super User

When you import from a cube you are freezing the results.  You should ignore the DSO field from the cube and create your own measure calculation.

I actually am doing that instead. That's good to know about the import from cube and freezing results though. 
So My Measures for DSO and Previous Year DSO are spot on for each month, Product level etc... its the correct formula. 
However when I try to break out that DSO Measure to Accrued DSO only I get errors and blanks. 
Applying Filters like
Calculate('DSO_Table[DSO_Measure], Filter('DSO_Table,[Account] IN {"Allowances", Accounts Received"}))

This is returning blank results for me when I try to filter the DSO measure by that Account field. In an Excel Pivot I am able to get those results no problem..... 

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.

Top Solution Authors