FIXED

Anonymous , Fixed is not easy 

examples

something like

Sumx(summarize(all(Table),[SCHDL_START_DATE].Year,[FINANCIAL_PROG_CODE],[Region Breakdown],[PRIM_PROG_CODE]), calculate( COUNTD([AUDIT_NO])))

fixed
Tableau - Avg({ FIXED [City (Geography)]:SUM([Gross Sales])})

Power BI

//Moved state to sales , or use removefilter(Sales[City])
Fixed City = CALCULATE(AVERAGEX(values(Geography[City]),[gross]), filter(all(sales), Sales[State] =max(Sales[State])))

//use next level of city
Fixed City 1 = CALCULATE(AVERAGEX(values(Geography[City]),[gross]), filter(all(Geography), Geography[State] =max(Geography[State])), REMOVEFILTERS(sales))

Fixed City 2 = CALCULATE(AVERAGEX(values(Geography[City]),[gross]), filter(all(Geography), Geography[State] =max(Geography[State])), all(sales))

refer

Fixed Level of Details in Power BI- Tableau Vs Power BI- Chapter 6- LOD- FIXED (Level of Details): https://youtu.be/QdnOHcZqkPU

I did't get the expected result,

Hi, Anonymous 

I'm not familiar with 'fixed' in Tableau. 

Can you provide sample data and your expected results in excel?

Best Regards,
Community Support Team _ Eason