Forum Discussion

pnem's avatar
pnem
Frequent Visitor
3 years ago
Solved

extract percentage from true/false column

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 calcul...
Need Help
Show and Tell
Tips and Tricks
  • Samarth_18's avatar
    Samarth_18
    3 years ago

    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:-

     

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
3 years ago

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:-