Subtotal of row in matrix table wrong

[Yashh]

in this table the total is not showing correct.
Please help

[Anonymous]

Hi @Yashh ,

The problem of incorrect totals and subtotals in DAX is a common problem for Power BI users. Please refer to the below blog to learn about how to fix it:

Learn How to Fix Totals and Subtotals in DAX (theexcelclub.com)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[Yashh]

Hello @DataVitalizer 

Hello all the total here is not correct 
This is the formula which i am using:

Total Count =

VAR FilteredData =

    FILTER(

        'MD4C-Multi',

        'MD4C-Multi'[MRPConfirmed] IN {"Stock","material-in time","material-too late","Purchase Requisition","No Order Conformation"}

    )

RETURN

    COUNTROWS(

        SUMMARIZE(

            FilteredData,

            'MD4C-Multi'[Material]

        )

    )
Please help me to correct it.
Best regards

[DataVitalizer]

Hi @Yashh 

Try replacing the filter context as below

...VAR FilteredData =
    FILTER(
        ALL('MD4C-Multi'),
        'MD4C-Multi'[M...

Did it work ? 👍 A kudos would be appreciated ‌‌📢 Mark it as a solution to help spreading knowledge

[DataVitalizer]

Try replacing the returned value by 

RETURN
DISTINCTCOUNT(FilteredData[Material])

Did it work ?  ‌‌ Mark it as a solution to help spreading knowledge
Was this exchange helpful? A kudos 👍 would be appreciated

[DataVitalizer]

Hi @Yashh 

Are you displaying values from a measure? if so, please share the used fomula.

Did it work ?  ‌‌ Mark it as a solution to help spreading knowledge
Was this exchange helpful? A kudos 👍 would be appreciated