Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |