Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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.
Hi @Anonymous
From what I see your measure is not filtering the selected entity.
Can we see your measure?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |