Insert single measure to table visual

[Anonymous]

Hi! I'm new to PowerBi an was trying to insert a mesure into a specific table cell (subledger account balance). Clearly, when I pull the measure, it populates the whole column.

This is what I need:

This is what I am getting:

Appreciate any help!

[Anonymous · Accepted solution]

Hi @Anonymous ,

If you want to specify a row to return results, you can see the following example

Sample data:

Measure = CALCULATE(SUM('Table'[Value]),FILTER('Table',[ID]="B"))

After checking 'Show items with no data', you can see that only row B returned the result.

If you still have doubts, please share the complete sample data and expected results. The screenshot you provided seems to be incomplete.

Best Regards,

Stephen Tao

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

[aj1973]

Hi @Anonymous 

From what I see your measure is not filtering the selected entity.

Can we see your measure?