How to count the Meaasure Numbers

[RanjanThammaiah]

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 the column total is more than 10% of the total number than 1 else 0.

No i wanted to count the total Numbers of the each row.ie Advisory SLI+Assurance SLI+TAS SLI+Tax SLI= Total count

AccountName	Advisory	Assurance	TAS	Tax	Total	Advisory %	Assurance %	TAS %	Tax %	Advisory SLI	Assurance SLI	TAS SLI	Tax SLI
ABC	2634310.18	233185.56	223787.01	56437.77	3147720.52	84%	7%	7%	2%	1
XYZ	2485145.27	12608.92	687796.92	64019.4	3249570.51	77%	0%	21%	2%	1		1
MNO	1528248.26	4667.29	-13404.21	17452.64	1536963.98	101%	0%	-1%	1%	1
					Logic	Advisory/Total	Assurance/Total	TAS/Total	Tax/Total	if Advisory % >10% then 1 else ""	if Assurance % >10% then 1 else ""	if TAS % >10% then 1 else ""	if Tax % >10% then 1 else ""

[v-yingjl]

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]

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 · Accepted solution]

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]

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]

Hi,

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

[amitchandak]

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