Forum Discussion

SravaniG's avatar
SravaniG
Helper I
5 years ago

Issue with Include Function in Tableau to Power BI

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.

Need Help

3 Replies

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    Hi SravaniG ,

     


    Try the following code:

    ttt =
SUMX (
    FILTER (
        ALLSELECTED('Table'[Date]),
        'Table'[Date] >= [Start DATE]
            && 'Table'[Date] <= [End Date]
    ),
    DISTINCTCOUNT ( 'Table'[ID] )
)
    • SravaniG's avatar
      SravaniG
      Helper I
      5 years ago

      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's avatar
        V-lianl-msft
        Community Support
        5 years ago

        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.