The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
78 | |
70 | |
52 | |
50 |
User | Count |
---|---|
120 | |
120 | |
76 | |
62 | |
61 |