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.
Hey all, please help me in converting this Tableau formula to DAX in PowerBi.
{ FIXED [research number]:sum({ FIXED [research number],[department_center]:MAX([department_personnel])})}
Help will be highly appreciated.
Thanks
Solved! Go to Solution.
HI @Aditya78,
According to your description and tabular expression, It seems like a common two-level aggregation expression. (sum of the max value based on correspond group fields)
For this scenario, you can try to use the following measure formula if helps:
Measure =
VAR currNumber =
VALUES ( 'Table'[research number] )
VAR summary =
SUMMARIZE (
ALLSELECTED ( 'Table' ),
[research number],
[department_center],
"max_DP", MAX ( 'Table'[department_personnel] )
)
RETURN
SUMX ( FILTER ( summary, [research number] IN currNumber ), [max_DP] )
Regards,
Xiaoxin Sheng
HI @Aditya78,
According to your description and tabular expression, It seems like a common two-level aggregation expression. (sum of the max value based on correspond group fields)
For this scenario, you can try to use the following measure formula if helps:
Measure =
VAR currNumber =
VALUES ( 'Table'[research number] )
VAR summary =
SUMMARIZE (
ALLSELECTED ( 'Table' ),
[research number],
[department_center],
"max_DP", MAX ( 'Table'[department_personnel] )
)
RETURN
SUMX ( FILTER ( summary, [research number] IN currNumber ), [max_DP] )
Regards,
Xiaoxin Sheng
Thanks for your kind response. But how can this work as in my mention formula. There are two expressions as well which are sum and max.
@Aditya78 , Try like
calculate([research number], allexcept(Table,[research number], [department_personnel]))
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 |
---|---|
43 | |
20 | |
18 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |