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.

amitchandak's avatar
amitchandak
Super User
6 years ago

Try like

calculate(count(table[account_number]),values(table[account_number]),Advisory SLI]+[Assurance SLI]+[TAS SLI]+[Tax SLI] >0)

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

  • RanjanThammaiah's avatar
    RanjanThammaiah
    Helper V
    6 years ago

    Hi,

     

    Thanks for the reply but i could end up with the below error.

     

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      Try

      calculate(count(table[account_number]),values(table[account_number]),filter(table,Advisory SLI]+[Assurance SLI]+[TAS SLI]+[Tax SLI] >0))

       

      if it does not work out. please share some data with formulas