The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello.
So I calculated a measure (and even a column) and when I represent it on a card or table the value is the one I want, so I don't think something is wrong with that measure. However I want to filter a table based on that value.
Example:
Id | Value |
1 | 299 |
2 | 299 |
3 | 299 |
4 | 300 |
5 | 300 |
6 | 300 |
If the measure value is 300, I want a table that contains only the ids 4, 5 and 6.
For that I created a new table and wrote this DAX formula:
But the table is empty. However when I type
Table = FILTER('TableB', 'TableB'[Value] = 300)
the table is not empty and it's correct.
When I represent that Measure on a table, I get this (for example):
Measure |
300 |
The measure is created on a different tableA.
the real value of a measure depends on its context. the context is different in a card visual and a calculated table.
User | Count |
---|---|
25 | |
10 | |
8 | |
7 | |
6 |
User | Count |
---|---|
32 | |
12 | |
10 | |
10 | |
9 |