Issue with Include Function in Tableau to Power BI

[SravaniG]

Hi,

I have calculation in tableau like below, I need to replicate this calculation in Power Bi.

sum({
INCLUDE DATEPART("month",[Date]) :
COUNTD(
IF [Date] >= [start Date] and [Date] <= [End date]
THEN [ID]
END
)
})

my calculation:

CALCULATE(

SUMX(ALLSELECTED([Date]), DISTINCTCOUNT('Table'[ID])),

FILTER(VALUES('Table'[Date]), 'Table'[Date]>=[Start DATE] &&  'Table'[Date]<=[End Date]

)

I have tried in multiple ways. With existance of month in table i am getting correct result, but if i remove month the result coming wrong like summing into number of months.Could anyone help me.

[MFelix]

Hi @SravaniG ,

Try the following code:

ttt =
SUMX (
    FILTER (
        ALLSELECTED('Table'[Date]),
        'Table'[Date] >= [Start DATE]
            && 'Table'[Date] <= [End Date]
    ),
    DISTINCTCOUNT ( 'Table'[ID] )
)

[SravaniG]

I need to show product type and this metric in table. it is showing like kind of grand total, Same value for all product types.

[V-lianl-msft]

Hi @SravaniG ,

It is very difficult to analyze without looking at the data and just by imagining.

Could you share the sample pbix via cloud service like onedrive for business or paste the sample data?

Please remove any sensitive data before uploading.

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