Forum Discussion

Mahmoodul's avatar
Mahmoodul
Icon for Helper I rankHelper I
6 years ago

Total/Sum working incorrectly in Power Bi

Hi team,

Thanks in Advance, I need some help regarding power BI Issue, Total is working incorrectly in Power BI, Please find the attchment for refrence.Can you please help me.

Row->SCS_NAME

Column ->Age Bucket

Values -> Distinct Count of Prime Part

4 Replies

  • Mahmoodul , distinct count can vary in total as it grand total is calculated again

     

    You can Try like

    sumx(values(table[SCS_NAME]), DistinctCount(Table[Prime Part]))

    sumx(summarize(table, table[SCS_NAME], Table[Age Bucket],"_1", DistinctCount(Table[Prime Part])),[_1])

    • Mahmoodul's avatar
      Mahmoodul
      Icon for Helper I rankHelper I

      sumx(values(table[SCS_NAME]), DistinctCount(Table[Prime Part]))

      Hi, I tried above one, This one given me correct total but DisticntCount is not correct, Can you please help me to get me correct Distinctcount.

  • v-alq-msft's avatar
    v-alq-msft
    Icon for Community Support rankCommunity Support

    Hi, Mahmoodul 

     

    I'd like to suggest you try the following measure to see if it helps.

    Result =
    IF (
        NOT ( ISFILTERED ( Table[SCS_NAME] ) )
            && NOT ( ISFILTERED ( Table[Prime Part] ) ),
        SUMX ( VALUES ( Table[SCS_NAME] ), DISTINCTCOUNT ( Table[Prime Part] ) ),
        DISTINCTCOUNT ( Table[Prime Part] )
    )

     

    Best Regards

    Allan

     

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