Forum Discussion
Insert single measure to table visual
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!
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.
2 Replies
- aj1973
Community Champion
Hi Anonymous
From what I see your measure is not filtering the selected entity.
Can we see your measure?
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.
