Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
HI Forum
i am using direct query with sql and trying to calculate a value using
TotalBudget = CALCULATE([SumBudget],FILTER(Fact_CE_AM_Revenue,Fact_CE_AM_Revenue[year]=MAX(Fact_CE_AM_Revenue[year])))
but i am facing below error
Function 'FILTER' is not supported in this context in DirectQuery mode.
Note : i have a year column by which budget is differentiated
it will be really helpful if you could help me out
Solved! Go to Solution.
Please enable following option and have a try again.
Best Regards,
Herbert
This is not a solution. It does not solve the problem.
Enabling below option did not work. Below is our DAX query -
MTD_Avg_Balance_Debt = TOTALMTD([Sumprin Debt],v_get_TransDate[TransDate])/(DATEDIFF(STARTOFMONTH(v_get_TransDate[TransDate]),max(v_get_TransDate[TransDate]),DAY)+1)
Works on desktop version, howver doesnt work once published to sever
Power BI
Hi,
Did you find any solution for this??
Please update, even I am facing same issue.
Regards,
Gourangi
Hi all, this issue is not solved as of May 25, 2018. We are using Power BI Report Server and the matching version of Power BI Desktop dated March 2018.
When we deploy a DirectQuery mode report containing measures like this, with "Allow unrestricted measures in DirectQuery mode" duly enabled
LatestCumulativeVarToTarget =
CALCULATE (
VALUES ( 'NonAffiliatedOutletSales'[CumulativeVarToTarget] ),
FILTER (
'NonAffiliatedOutletSales',
'NonAffiliatedOutletSales'[CalculateDate]
= MAX ( 'NonAffiliatedOutletSales'[CalculateDate] )
)
)
and "Save As" to Power BI Report Server, when the report is rendered visuals that use such measures display with the circled X and text "Can't display the visual. See details." The details message is:
Not solved.
Is this the expected behavior?
I also have the same problem when I used directquery mode. On the other hand, in import mode, this measure is working.
LatestTurbidity = CALCULATE(MAXA(MsgJamhamTest1[Value]), FILTER(MsgJamhamTest1,[Type]="Turbidity"&&[UpdateTime]=MAX([UpdateTime])))
I have a similar issue, i.e. you can get away with unrestricted measures in PBI Desktop only for it to fail on the Reporting Server. Did you find a viable workaround? Can "unrestricted measures" bet set for the Reporting Server as well, and if so how? Any information would be greately appreciated.
RE
Enabling below option did not work. Below is our DAX query -
MTD_Avg_Balance_Debt = TOTALMTD([Sumprin Debt],v_get_TransDate[TransDate])/(DATEDIFF(STARTOFMONTH(v_get_TransDate[TransDate]),max(v_get_TransDate[TransDate]),DAY)+1)
Works on desktop version, howver doesnt work once published to sever
Power BI
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
73 | |
57 | |
38 | |
35 |
User | Count |
---|---|
83 | |
68 | |
59 | |
46 | |
45 |