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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Rows and Column Totals are wrong in a Power BI Matrix

Dear All,

I have a measure in SSAS Tabular Cube.  
Measure:= (Sum(Quantity)/DistinctCount(Transactions)) * 1000

I am displaying data in Power BI Matrix as 
Display Data 1.png

Both Column and Line Total are wrong. Accoding to my understanding Total are coming wrong due to Expression in a measure. To solve this I tried , All Function. Calculate separately Quantity and Transactions. Also try All(Product Types), All(Store) in DAX Calculation but I am not able to get the Correct Result.

Quantity and Transaction are stored in Fact Sales and both Dimentions are Attached with Fact Sales.

I see solutions From the Power BI Forum but not able to get the close sokution.

 

Appreciate immeidate help.

 

Azhar

1 ACCEPTED SOLUTION
Anonymous
Not applicable

By using Sumx , We can have the correct Total, but issue with SUMX is Performance. 

Right now I am using SUMX and Its works for me. Can some one tell me how I can improve the performance.

Measure=SumX(Sales, Quantity * Transactions) * 1000.

View solution in original post

10 REPLIES 10

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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