TransWikia.com

Row total not being calculated correctly in Matrix visualisation [Power BI]

Data Science Asked by poiuy9876 on August 4, 2021

I have the following measures:

StockSales CY = CALCULATE(COUNT('ds SalesRetail'[StockID]),ALLSELECTED('ds SalesRetail'))
Billed Quantity CY = CALCULATE(SUM(AQA0ZSPM________PRICE_REBAT_SQ_View[Billed Quantity]))
Pen. Rate CY = DIVIDE(AQA0ZSPM________PRICE_REBAT_SQ_View[Billed Quantity CY],'ds SalesRetail'[StockSales CY])

I would like my "Row subtotal" to be calculated as follows:
TOTAL Billed Quantity CY/ TOTAL StockSales CY.

However, this is not happening and the Row total is equal to the sum of the percentages above.

What am I doing wrong and how do I fix it?

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP