USE Tableau LOD expression in PBI

[jhlee2611]

hi, my comapany migration Tableau to PBI.
What I am trying to create is as follows.

there are Call ID, Detail ID & Product

The result I desire is as follows.

but with follow expression, i got anoter result

N Product Call=

        CALCULATE(

            DISTINCTCOUNT('table'[Detail ID]),

            ALLEXCEPT('table','table'[Call ID])

        )

follow is Expession that i used in Tableau
{Fixed [Call ID] : countd[Detail ID]}

How Can i get correct result? please help.

[lbendlin · Accepted solution]

Power BI does not have a concept of dynamic buckets.  You need to bring your own.

N Product Call = {{1},{2},{3}}

Then you can do a cartesian with your Product Names, and add the measure

Detail(#) =
COUNTROWS (
    FILTER (
        ADDCOLUMNS (
            VALUES ( 'Table'[Call ID] ),
            "ct", CALCULATE ( COUNT ( 'Table'[Detail ID] ), REMOVEFILTERS ( 'Table'[Product] ) )
        ),
        [ct] = SELECTEDVALUE ( 'N Product Call'[Value] )
    )
)

See attached