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.
Now, my calculated table looks like this:
FRU Status intermediate table =
ADDCOLUMNS(
VALUES('All Project v2'[Project Name]),
"Flag", [stat chart]
)
VALUES() here returns all values of the [Project Name] column.
I need it to return values based on the column 'All Project v2'[Dashboard Created] = "Yes", so if the 'project' has 'dashboard' - return the column.
Solved! Go to Solution.
FRU Status intermediate table =
ADDCOLUMNS (
CALCULATETABLE (
VALUES ( 'All Project v2'[Project Name] ),
'All Project v2'[Dashboard Created] = "Yes"
),
"Flag", [stat chart]
)
Hi @Anonymous
please try
FRU Status intermediate table =
SUMMARIZE (
FILTER ( 'All Project v2', 'All Project v2'[Dashboard Created] = "Yes" ),
'All Project v2'[Project Name],
"Flag", [stat chart]
)
Hi @Anonymous
please try
FRU Status intermediate table =
SUMMARIZE (
FILTER ( 'All Project v2', 'All Project v2'[Dashboard Created] = "Yes" ),
'All Project v2'[Project Name],
"Flag", [stat chart]
)
I tried it, and it works fine, but it doesn't solve the further problem...
Well, technically, you guys gave me the solution, so...
FRU Status intermediate table =
ADDCOLUMNS (
CALCULATETABLE (
VALUES ( 'All Project v2'[Project Name] ),
'All Project v2'[Dashboard Created] = "Yes"
),
"Flag", [stat chart]
)
It does work, yes. But a new problem arose: I can't create a relationship with the table I am pulling columns from due to circular dependency.
With Values() it doesn't have CD
use DISTINCT instead of VALUES
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 |
---|---|
45 | |
28 | |
21 | |
11 | |
8 |
User | Count |
---|---|
77 | |
50 | |
46 | |
16 | |
12 |