Incorrect total for column in matrix

[Abrar786]

Hello,

I am getting an incorrect total for my measure. Please see below for the details of my measure.

Increase Sale =

VAR customers =

    FILTER (

        ADDCOLUMNS (

            DISTINCT ( invoices_details[customer_no] ),

            "@CYSale", [Total Sale],

            "@LYSale", [LY Sale],

            "@SaleDiff", [Total Sale] - [LY Sale]

        ),

        [@CYSale] > 0

            && [@LYSale] > 0

            && [@CYSale] > [@LYSale]

            && COUNTROWS (

                FILTER (

                    'category',

                    [@SaleDiff] >= 'category'[category min value]

                        && [@SaleDiff] < 'category'[category max value]

                )

            ) > 0

    )

RETURN

    SUMX ( customers, [@SaleDiff] )

Thank you in advance for the help.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[Ahmedx]

write another measure like this

SUMX ( VALUES('table'[category Name]), [Increase Sale] 

[amitchandak]

@Abrar786 , Try two measures like

Inc =COUNTROWS (
FILTER (
'category',
[@SaleDiff] >= 'category'[category min value]
&& [@SaleDiff] < 'category'[category max value]
)
)


Increase Sale =

Sumx(FILTER (
ADDCOLUMNS (
values ( invoices_details[customer_no] ),
"@CYSale", [Total Sale],
"@LYSale", [LY Sale],
"@SaleDiff", [Total Sale] - [LY Sale]
),
[@CYSale] > 0
&& [@LYSale] > 0
&& [@CYSale] > [@LYSale]
&& [Inc]> 0
),[@SaleDiff])