Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi all,
I have true/false column data and I want to calculate percentage of those true/false values from subcategory to category.
Here is example of the data.
I want to calculate status column
Please let me know if you have any advice how to do it
Solved! Go to Solution.
Hi @pnem ,
You can create a column as below:-
STATUS =
var _true = COUNTROWS(FILTER('Table 2','Table 1'[ID]='Table 2'[ID CAT] && 'Table 2'[STATUS] = 1))
var _total = COUNTROWS(FILTER('Table 2','Table 1'[ID]='Table 2'[ID CAT]))
return DIVIDE(_true,_total,0)
Refer a file below:-
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @pnem ,
You can create a column as below:-
STATUS =
var _true = COUNTROWS(FILTER('Table 2','Table 1'[ID]='Table 2'[ID CAT] && 'Table 2'[STATUS] = 1))
var _total = COUNTROWS(FILTER('Table 2','Table 1'[ID]='Table 2'[ID CAT]))
return DIVIDE(_true,_total,0)
Refer a file below:-
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
108 | |
102 | |
94 | |
71 |
User | Count |
---|---|
173 | |
134 | |
132 | |
102 | |
95 |