Forum Discussion
Fixed Tableau function into Power BI DAX
Hi Anonymous ,
According to your description, the fixed function corresponds to the function in powerbi to keep the fields corresponding to the grouping role. There are several ways to achieve this effect.
M_sum1 = CALCULATE ( [sum], ALLEXCEPT ( 'Table', 'Table'[Bill Code], 'Table'[Code], 'Table'[Work Order] ) )M_sum2 = CALCULATE ( [sum], FILTER ( ALL ( 'Table' ), 'Table'[Code] = MAX ( 'Table'[Code] ) && 'Table'[Work Order] = MAX ( 'Table'[Work Order] ) && 'Table'[Bill Code] = MAX ( 'Table'[Bill Code] ) ) )For more details, you can read related blog as below.
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI
If the problem is still not resolved, please point it out. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
According to your description, the fixed function corresponds to the function in powerbi to keep the fields corresponding to the grouping role. There are several ways to achieve this effect.
M_sum1 =
CALCULATE (
[sum],
ALLEXCEPT ( 'Table', 'Table'[Bill Code], 'Table'[Code], 'Table'[Work Order] )
)M_sum2 =
CALCULATE (
[sum],
FILTER (
ALL ( 'Table' ),
'Table'[Code] = MAX ( 'Table'[Code] )
&& 'Table'[Work Order] = MAX ( 'Table'[Work Order] )
&& 'Table'[Bill Code] = MAX ( 'Table'[Bill Code] )
)
)
For more details, you can read related blog as below.
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI
If the problem is still not resolved, please point it out. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- {fixed [Code],[Work Order]: MIN(DATE([Quote Recvd Dt]))}
Here [quote Recvd dt] is a date column, Need to convert this Tableau function into Power BI DaxAnonymous , try like
calculate(MINX(Table, datevalues(Table[Quote Recvd Dt])), filter(all(table), Table[Code] =max(Table[Code]) && Table[Work Order] = max([Work Order])))
= CALCULATE ( MIN('Table1'[Quote Recvd Dt]) , ALLEXCEPT ( 'Table1', 'Table1'[Code], 'Table1'[Work Order] ) )Hi Anonymous ,
It seems that this is the post I came across earlier that has provided the relevant solution.
Refer to the following link: Solved: Re: Fixed Tableau function into Power BI DAX - Microsoft Power BI Community
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
