Forum Discussion

Aazam's avatar
Aazam
Icon for Helper I rankHelper I
2 years ago

Row is not adding in SUM

I am having an issue in total, I have created a templet through dataflow, and I know the issue is it is getting 0 value from that templet that is my native behavior of PowerBI is not calculating this...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
2 years ago

Aazam 

What about this?

 

If not then what do you have? What distinguishes the percentage values from others? Any flag column? 

Aazam's avatar
Aazam
Icon for Helper I rankHelper I
2 years ago

It is a template I created. These fields are coming from the same table GL Department Accounts-Stack but the column is Accounts Group  ('GL Department Accounts-Stack'[GL Departments]

 




 

 

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Aazam 

    In the accounts group column what distinguishes the percentage values

    • Aazam's avatar
      Aazam
      Icon for Helper I rankHelper I
      2 years ago

      I updated the answer above.

      Again attaching the screenshot

       

      • tamerj1's avatar
        tamerj1
        Icon for Community Champion rankCommunity Champion
        2 years ago

        Aazam 

        [Combine-Stack-Total Actual MTD -- Testing Aazam ] =
        SUMX (
        FILTER (
        SUMMARIZE (
        'GL Department Accounts-Stack',
        'GL Department Accounts-Stack'[Accounts Group],
        'GL Department Accounts-Stack'[GL Department]
        ),
        NOT CONTAINSSTRING ( 'GL Department Accounts-Stack'[GL Department], "%" )
        ),
        "Rest of the code"
        )