Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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!
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.....
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.