Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello Folks,
In the below table I have to add a new column and reference a sum of all True values in each row.
The final output in that new column should be:
Kind of portfolio assets | Count |
Bonds | 4 |
Company Ceo | - |
Investment Funds | 3 |
Shares | 3 |
I created a measure and used the following formula however it didn't work
COUNTAX(FILTER('Table',[Company1]=TRUE()),TRUE())
Please help.
Thanks and regards
Solved! Go to Solution.
HI @Anonymous ,
I meant a Calculated Column in Power Bi Desktop.
Regards,
Harsh Nathani
It worked Harsh, however, is there any way to make it dynamic?
Regards.
HI @Anonymous ,
You can unpivot.
Select 1 column and click on Unpivot Columns --> Select Unpivot Other Columns
Your Table will change to the below.
Post this, you can apply filter.
Apply filter First and then change value to Count.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi @Anonymous ,
You can create a new Column.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
It worked Harsh, however, is there any way to make it dynamic?
Regards.
HI @Anonymous ,
You can unpivot.
Select 1 column and click on Unpivot Columns --> Select Unpivot Other Columns
Your Table will change to the below.
Post this, you can apply filter.
Apply filter First and then change value to Count.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Working as expected. Thanks Harsh.
A last question if I may or I will open a new discussion, with this last approach I want to show the entire set of table with this new dynamic way of getting the value count - how to do that ? do I have to merge or some other magic ?
Thanks in advance.
Thanks for your quick reply Harsh.
You mean a Custom column ?
If so, getting this error
HI @Anonymous ,
I meant a Calculated Column in Power Bi Desktop.
Regards,
Harsh Nathani
User | Count |
---|---|
116 | |
73 | |
60 | |
48 | |
48 |
User | Count |
---|---|
171 | |
122 | |
60 | |
59 | |
56 |