Tableau formula to dax

[Anonymous]

I'm currently in the process of transitioning Tableau reports to Power BI, and I'm encountering challenges with converting certain Tableau formulas into DAX expressions. One formula in particular has me stumped, and I'm seeking assistance to translate it. The Tableau formula involves the use of the FIXED function, which I'm not familiar with, and I'm unsure how to replicate its functionality in DAX. Here's the Tableau formula:

IF { FIXED [Sales Document]: COUNT( IF [OT RDD HDR Flag | T,F] = TRUE AND [IF RDD HDR Flag | T,F] = TRUE THEN [Sales Document] END ) } = {FIXED [Sales Document] : COUNTD([Sales Document Item])} THEN 1 ELSE 0 END

Any guidance or assistance with this translation process would be greatly appreciated."

[Anonymous]

Hi @Anonymous ,

First of all, many thanks to  for your very quick and effective replies.

Based on the description, please try the following dax formula.

SalesDocument = 
VAR SalesDocumentConditionCount = 
    CALCULATE(
        COUNTROWS('Table'),
        FILTER(
            'Table',
            'Table'[OT RDD HDR Flag | T,F] = TRUE && 'Table'[IF RDD HDR Flag | T,F] = TRUE
        ),
        ALLEXCEPT('Table', 'Table'[Sales Document])
    )
VAR SalesDocumentItem = 
    CALCULATE(
        DISTINCTCOUNT('Table'[Sales Document Item]),
        ALLEXCEPT('Table', 'Table'[Sales Document])
    )
RETURN
    IF(SalesDocumentConditionCount = SalesDocumentItemCount, 1, 0)

You can view the following documents to learn more about Hybrid Tables.

Migrating from Tableau to Power BI - Microsoft Fabric Community

Solved: Understanding DAX Expressions in Power BI vs. Tabl... - Microsoft Fabric Community

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AntrikshSharma]

@Anonymous Prepare a sample dataset and include the result column with explanation, that way we don't need to identify which Tableau function does what, from the result itself deducing DAX is pretty easy.