Forum Discussion

Grahamwest's avatar
Grahamwest
Regular Visitor
8 years ago

Need help with formula

Hello Folks,   I got an example table with:     Batch                           Qty (Kg)          Auction no. A1025                           5                                1 A1025          ...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Grahamwest,

 

Based on test, this formula works when I test to choose multiple unique records in slicer.

 

 

 

Have you modified the group column or slicer column? If not, please share the sample pbix file to test.

 

BTW, I also update the formula condition to confirm it can correct filter the total row, maybe you can try it.

Qty(Kg) = 
IF (
    COUNTROWS ( 'sample' ) <> COUNTROWS ( ALLSELECTED ( 'sample' ) ),
    CALCULATE (
        LASTNONBLANK ( 'sample'[ Qty (Kg)], [ Qty (Kg)] ),
        ALLSELECTED ( 'sample'[Auction no.] )
    ),
    SUMX (
        SUMMARIZE (
            ALLSELECTED ( 'sample' ),
            'sample'[Batch],
            "QTY", DISTINCT ( 'sample'[ Qty (Kg)] )
        ),
        [QTY]
    )
)

 

 

Regards,

XIaoxin Sheng

Grahamwest's avatar
Grahamwest
Regular Visitor
8 years ago

Hi Anonymous

 

I have tried this one too, but it is giving me same result,

 

Can I have you email Id so that I can send you the data and that may be esier for you to work upon?

 

Thanks,

Graham

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Grahamwest,


    You can share the sample link with private message, I will check and test on it.

     

    Regards,

    Xiaoxin Sheng