Forum Discussion

jereaallikko's avatar
jereaallikko
Helper III
5 years ago
Solved

Help With Blank Values Follow-up

Hi all,   I need help with DAX or custom column. I am following mandatory fields that my team needs to fill. So, if some field is missing, a table shows blank value on a cell.    Basically, I wou...
Need Help
Tips and Tricks
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    Hi jereaallikko 

    You can take steps below for reference.

    1. Go to Power Query Editor, you need to select all the columns, then

    Get

    2. Repeat the operation, and replace “List.NonNullCount” with “List.Count”

    3. Add a custom column to get a diff, and change its type to Whole Number

    4. Remove the two columns if you want

    5. Create a measure

    count = CALCULATE(SUM('Table'[Blank]),GROUPBY('Table','Table'[reporter]))

    Hope it helps.

     

    Best Regards,

    Community Support Team _ Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

v-xiaotang's avatar
v-xiaotang
Community Support
5 years ago

Hi jereaallikko 

You can take steps below for reference.

1. Go to Power Query Editor, you need to select all the columns, then

Get

2. Repeat the operation, and replace “List.NonNullCount” with “List.Count”

3. Add a custom column to get a diff, and change its type to Whole Number

4. Remove the two columns if you want

5. Create a measure

count = CALCULATE(SUM('Table'[Blank]),GROUPBY('Table','Table'[reporter]))

Hope it helps.

 

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.