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.
Since my table returned is not base table and it is produced using this code
VAR Y = ADDCOLUMNS ( X, "@RANK", RANKX ( X, [@COUNT],,, DENSE ) )
VAR Z = FILTER (Y, [@RANK] = 1)
Z table looks like this
Country | @Anonymous | @RANK |
Australia | 2677 | 1 |
How do I get the value "Australia"?
Solved! Go to Solution.
Hi @stribor45,
Sorry about that. I had made a typo, where I had put two brackets instead of one.
Try this:
FIRSTNONBLANK(SELECTCOLUMNS(FILTER (Y, [@RANK] = 1),"Country",Y[Country]),[Country])
This code works for me in DAX Studio but when I move it over to my report data doesnt change when I move slicer
DEFINE
VAR SummaryTable =
SUMMARIZE(
FILTER('AGENTS TABLE', 'AGENTS TABLE'[Country] <> "Canada"),
'AGENTS TABLE'[Country],
"TotalCount", COUNT('AGENTS TABLE'[Call ID])
)
VAR RankedTable =
ADDCOLUMNS(
SummaryTable,
"Rank",
RANKX(SummaryTable, [TotalCount], , DESC)
)
EVALUATE
RankedTable
Hi @stribor45 ,
Can you try like this:
VAR Z = FIRSTNONBLANK(SELECTCOLUMNS(FILTER (Y, [@RANK] = 1),"Country",Y[Country])),[Country])
that didnt work for me. The syntax for '.' is incorrect
Hi @stribor45,
The formula I gave can be used for a measure, but in terms of EVALUATE it expects a table as a input.
Can you try the same inside a measure, preferably in Power BI desktop?
Yes thats why I typed "Evaluate X" instead of Z. I had same error in PBI measure as well
Hi @stribor45,
Sorry about that. I had made a typo, where I had put two brackets instead of one.
Try this:
FIRSTNONBLANK(SELECTCOLUMNS(FILTER (Y, [@RANK] = 1),"Country",Y[Country]),[Country])
User | Count |
---|---|
25 | |
10 | |
8 | |
7 | |
6 |
User | Count |
---|---|
32 | |
12 | |
10 | |
10 | |
9 |