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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

SSAS - Slicer Not filtering summary cards and tables correctly (showing wrong results)

I have a dashboard with slicers, a chart, a summary card and a table. The chart works fine with all the slicers but not with the summary card and the table as those 3 show different results for the same measures and the same dimensions. The summary card and the table tend to show grand totals all the time, but if I switch column order for the measures in the table for example, the correct results are displayed. This is really confusing and annoying, especially for our users.
Status: New
Comments
d_kamning
New Member
I am not able to upload a picture. Please help
d_kamning
New Member
I am using an SSAS Multidimensional cube as source. This issue is only found on our PowerBI dashboards. Using Excel PowerPivot or SQL Management Studio with the same source and the same layout, I get the correct results.
fbcideas_migusr
New Member
Status changed to: New