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 everyone,
i have created a variable tabel inside a measure and need to pull column1 value based on maxium value in column 2. However i can't seem to find a function that will pull or look up a value from a variable table as the table does not really exists. it is only summarized inside the measure.
Basically in the formula below, i need to pull the DOW value where [count] is maximum
not sure if i fully get you.
Supposing your table like this:
DOW |
1/1/2023 |
1/2/2023 |
1/2/2023 |
1/3/2023 |
1/3/2023 |
1/3/2023 |
then try to plot a measure like this:
Measure =
VAR _table =
ADDCOLUMNS(
VALUES(TableName[DOW]),
"Count",
CALCULATE(COUNTROWS(TableName))
)
VAR _countmax = MAXX(_table, [Count])
RETURN
MINX(
FILTER(_table, [Count] = _countmax),
[DOW]
)
it worked like:
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |