Forum Discussion

RanjanThammaiah's avatar
RanjanThammaiah
Helper V
6 years ago
Solved

How to count the Meaasure Numbers

Hi All,   Can some one help me to count the numbers that resulted from the measures?   I could get the total numbers from the Input and i have calculated the % of the each column by its total. if...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi RanjanThammaiah ,

    You can try this link:

    PBIX 

     

    And the row total of each account is in the end of row:

     

    Best Regards,

    Yingjie Li

     

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

v-yingjl's avatar
v-yingjl
Community Support
6 years ago

Hi RanjanThammaiah ,

You can create the following measure to solve your problem:

 

Total Number = SUMX(DISTINCT('table'[AccountName]),[Advisory % SLI]+[Assurance % SLI]+[TAS % SLI]+[TAX % SLI])

 

You will get the result like this:

 

Here is the demo , please try it:

PBIX 

 

Best Regards,

Yingjie Li

 

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

  • RanjanThammaiah's avatar
    RanjanThammaiah
    Helper V
    6 years ago

    Hi,

     

    thanks for the reply. is there anyway we can ge the row total of each Account?

     

    i have ended up with the below error once after i add the formula. and drag that to my table.

     

    All the columns types are in Whole numbers except the account name column.

     

    And  i am unable to download the Pbix file. 

    • v-yingjl's avatar
      v-yingjl
      Community Support
      6 years ago

      Hi RanjanThammaiah ,

      You can try this link:

      PBIX 

       

      And the row total of each account is in the end of row:

       

      Best Regards,

      Yingjie Li

       

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