Having difficulty converting Tableau measure to PowerBI Dax.

[vswar]

Hi,

I am in the process of converting few Tableau dashboards into Power BI but having difficulty figuring out this formula.  Can someone point me to right direction. 

Bounce Rate Formula : 

SUM({ FIXED [Matmovisit ID] : 

    SUM(

              IF { INCLUDE [Matmovisit ID] : SUM([interactions]) } = 1

                    THEN 1

              ELSE 0

              END

           )}

    ) / COUNT([Matmovisit ID])

Thanks in advance!

[DataNinja777 · Accepted solution]

Hi @vswar ,

To convert your Tableau Bounce Rate formula into Power BI, you can use a DAX approach to replicate the functionality of Tableau's FIXED and INCLUDE functions. Here’s how to structure the formula:

To replicate { INCLUDE [Matmovisit ID] : SUM([interactions]) } = 1, you’ll need to calculate interactions per Matmovisit ID and flag those with only one interaction.

InteractionsPerVisit = 
    CALCULATE(
        SUM('Table'[Interactions]),
        ALLEXCEPT('Table', 'Table'[Matmovisit ID])
    )

BounceFlag = 
    IF([InteractionsPerVisit] = 1, 1, 0)

Then, sum up the visits with only one interaction across all Matmovisit ID values.

TotalBounces = 
    CALCULATE(
        SUMX(
            VALUES('Table'[Matmovisit ID]),
            IF([InteractionsPerVisit] = 1, 1, 0)
        )
    )

Now that you have the count of bounces, you can divide by the total number of visits to get the bounce rate.

BounceRate = 
    DIVIDE(
        [TotalBounces],
        COUNT('Table'[Matmovisit ID]),
        0
    )

In summary:

• InteractionsPerVisit calculates the total interactions per Matmovisit ID.
• BounceFlag flags a visit as a bounce if interactions equal 1.
• TotalBounces calculates the total bounces across all visits.
• BounceRate divides total bounces by the total number of visits to get the bounce rate.

This should give you a similar outcome to your Tableau formula.

Best regards,

[vswar]

Thanks you so much for this. Your DAX functions are calculating the data precisely. 

[Ritaf1983]

Hi @vswar 

Please provide a workable sample data and your expected result from that. It is hard to figure out what you want to achieve from the description alone.  

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

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