Counting values in query and using counted value in equation?

Question

Hi, I'm new to PowerBI, I was wondering what the best way to count values in a group then use the count in a calculation, I have a query like this:&nbsp;0 1&nbsp; &nbsp; 2&nbsp; &nbsp; 3a&nbsp; .&nbsp; &nbsp; &nbsp;.&nbsp; &nbsp; &nbsp;Ta&nbsp; .&nbsp; &nbsp; &nbsp;.&nbsp; &nbsp; &nbsp;Ta&nbsp; .&nbsp; &nbsp; &nbsp;.&nbsp; &nbsp; &nbsp;Fb&nbsp; .&nbsp; &nbsp; &nbsp;.&nbsp; &nbsp; &nbsp;Tb&nbsp; .&nbsp; &nbsp; &nbsp;.&nbsp; &nbsp; &nbsp;nullb&nbsp; .&nbsp; &nbsp; &nbsp;.&nbsp; &nbsp; &nbsp;Fb&nbsp; .&nbsp; &nbsp; &nbsp;.&nbsp; &nbsp; &nbsp;F&nbsp;I understand that if you create a Table from this query, it will group by a and b and you can create counts of T or F, where T and F are strings with null values, within the table, but would you use the counts in a dependent calcuation? So that the table looked like:&nbsp;0&nbsp; 1&nbsp; &nbsp;2&nbsp; &nbsp;TF_calca&nbsp; &nbsp;.&nbsp; &nbsp;.&nbsp; &nbsp; T_count^2/F_count^2&nbsp;b&nbsp; &nbsp;.&nbsp; &nbsp;.&nbsp; &nbsp;&nbsp;T_count^2/F_count^2&nbsp;&nbsp;Thanks in advance!

v-danhe-msft · Accepted Answer

Hi&nbsp;hanr&nbsp;,
Based on my test, you could refer to below formula:
Test = SUMMARIZE('Table1','Table1'[0],"A",
        (CALCULATE(COUNT(Table1[3]),FILTER('Table1','Table1'[3]="T"))*CALCULATE(COUNT(Table1[3]),FILTER('Table1','Table1'[3]="T")))
        /(CALCULATE(COUNT(Table1[3]),FILTER('Table1','Table1'[3]="F"))*CALCULATE(COUNT(Table1[3]),FILTER('Table1','Table1'[3]="F"))))
Result:

You could also downlad the pbix file to have a view.
&nbsp;
Regards,
Daniel He

Forum Discussion

Counting values in query and using counted value in equation?

1 Reply

Related content

Counting nulls

Count Of Drivers

Count Measure

count distinct

Counting Active employees per month