Dax

[pstanek]

Problem 1

Name 1 Number 1

.

.

Name n  Number n.

How can I calculate column with values Number i / Count( Name i).

Problem 2

How can I calculate number of blank values.

When I transform column TEXT to TEXT-Count, I will get blank value for blank values.

[v-caliao-msft]

Hi Pstnaek,

You can add a calculated column to get the count number for each Name
Count = CALCULATE(COUNT(CountValue[Number]),ALLEXCEPT(CountValue,CountValue[Name]))
And then get the value Number i / Count( Name i)
Number/Count = CountValue[Number]/CountValue[Count]

To count blank value, you can use COUNTBLANK function
CountBlank = COUNTBLANK(CountValue[Number])

Regards,

Charlie Liao

[pstanek]

Countblank does not work within DirectQuery, that is the problem

[pstanek]

add Problem 1 columns are from related tables

[pstanek]

I tried this

column = table1[number]/table2[pocet]

Pocet=COUNTAX(table2;table2[name])

, but it says that in direct query Countax can not be used.