Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
Is it possible to translate below expression to DAX or is there another way of achieving the outcome in PBI? I want to translate a table from Qlik into a matrix visual but i cant figure out how to get the aggr equivalent.
timestamp(
min({<ColumnX -= {0}>}aggr(
min({<ColumnX -= {0}>} ColumnN,', ')
,ColumnZ,ColumnY, ColumnX))
)
BR Tommy
Thanks for the quick reply, but i dont fully understand how this will aggregate over several columns? I only see Column1 = ColumnX and Column2 = ColumnN.
The Qlik aggr function, aggregates a field by a set of fields, I will try to translate into natural language your measure but it's better to provide a expected result to be more accurate
timestamp( -- format into time stamp
min( -- get the minimum value of ..
{<ColumnX -= {0}>} -- set analysis to filter out ColumnX = 0,
aggr(
min({<ColumnX -= {0}>} ColumnN,', ')
,ColumnZ,ColumnY, ColumnX)) -- we get field ColumnN, where row of ColumnX = 0 are filtered out aggregated by ColumnZ,ColumnY, ColumnX
)
if I try to translate into dax these components :
AggMinValueMeasure =
VAR AggrMin = SUMMARIZE (
ADDCOLUMNS(
CALCULATETABLE (
SUMMARIZE (
'Table',
'Table'[Column1],
'Table'[Column2]
),
'Table'[Column1] <> 0
)
,
"Column1-1", 'Table'[Column1],
"Column2-2",'Table'[Column2]
),
"_Min", Min('Table'[Column2])
)
Return AggrMin
And then format the measure into timestamp in the graphical UI.
Hope this helps.
User | Count |
---|---|
57 | |
33 | |
18 | |
18 | |
15 |
User | Count |
---|---|
94 | |
86 | |
39 | |
22 | |
22 |