Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 "" |
Solved! Go to Solution.
Hi @RanjanThammaiah ,
You can try this link:
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.
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:
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.
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.
Hi @RanjanThammaiah ,
You can try this link:
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.
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
Hi,
Thanks for the reply but i could end up with the below error.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |