How to convert Tableau measures to Power bi Dax?

[freakinaditya]

Hi,

I am in the process of converting a load of Tableau dashboards into Power BI but cannot figure out how to translate this particular measure and was hoping someone could point me in the right direction:

{ EXCLUDE [DATE] : AVG ( { INCLUDE [CATEGORY],[DATE] : AVG ( IF {MAX([DATE])} = [DATE]  THEN [TOTAL_SALES] END) }) }

Here [TOTAL_SALES] is a measure.

Thanks in advance!!

[V-lianl-msft]

Hi @freakinaditya ,

Try:

Average total_sales = CALCULATE(AVERAGEX( 
    SUMMARIZE('table', 'table'[CATEGORY], 'table'[DATE], "TOTAL_SALES", [TOTAL_SALES])), 
    [TOTAL_SALES] 
),FILTER(ALLSELECTED('table'[DATE]),'table'[DATE]=[LARGEST DATE]))

If the problem persists,could you share the sample data and the result you expected?

How-to-provide-sample-data-in-the-Power-BI-Forum 

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

[amitchandak]

@freakinaditya , difficult to tell . Try like

averageX(values(Table[CATEGORY]),calculate([TOTAL_SALES], filter(Table,Table[Date] = max(Table[Date])) allexcept(Table,Table[CATEGORY],Table[DATE])))

If not

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.