Forum Discussion

pstanek's avatar
pstanek
Icon for Post Patron rankPost Patron
10 years ago

Dax

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 ...
Need Help
Tips and Tricks
v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

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's avatar
    pstanek
    Icon for Post Patron rankPost Patron
    10 years ago

    Countblank does not work within DirectQuery, that is the problem