Forum Discussion

RanjanThammaiah's avatar
RanjanThammaiah
Icon for Helper V rankHelper 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.

RanjanThammaiah's avatar
RanjanThammaiah
Icon for Helper V rankHelper V
6 years ago

Hi,

 

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

 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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