Values from database are not displayed in PowerBI

CKa, Is it a column or measure? Measure using time intelligence like datesytd, sameperiodlastyear, perviousyear etc need a date in context to calculate these. I think you are using a measure. select some date, you should be able to get value.

Why DATESMTD is still blank, even after having the correct TI Setup: https://youtu.be/j0ug-XQgZtg

Why previousmonth does not give result when datesmtd is giving it: https://youtu.be/1KkoJehRVeg

Hi,CKa.I am glad to help you.
Hello,amitchandak ,thanks for your concern about this issue.

Your answer is excellent! And I would like to share some additional solutions below

I tried to reproduce your problem by creating a SSAS tabular model in visual studio and creating a measure with sum function in it, deploying it to SSMS and then making live connections through powerBI.

Unfortunately I did not succeed in reproducing your problem, all the measures are displayed correctly and the correct values are calculated even after adding external slicer filter fields.
You also mentioned that your measure only sums the Sales table [NetSalesPreviousyear].

Here is my test:

Measure 1:=SUM(Table_1[Time])
Measure 2:=SUM('Table_1'[time 2])
CalculatedTable 1 =VALUES(Table_1)
Measure 3:=SUM('CalculatedTable 1'[Time])

So I have a couple of questions: are you creating multiple measures and only Measure in these measures
definition Net Sales previous year:= sum(Sales[NetSalesPreviousyear]) displays normally when SSAS taular model is created, but after connecting to power bi
Null values are displayed.
Does this measure depend on the results of other measures or is it a direct calculation?
You can try to re-create a simple demo with the problematic measure alone and then re-connect it with power BI Desktop to see if there is a problem.

Here are my recommended directions for checking:
1. Check if the data source is connected properly, make sure the connection between power BI and AS model is normal and stable.
2. Check if there are any problems with the measure formula: although the measure you provided is very simple, check that the correct data (fields) are referenced.
3. Make sure the data model is updated
4. check if there are data access permissions: if you have set access permissions in the AS model (RLS/OLS in AS) it is very important to set access permissions as these settings affect the scope of the data that the user can access and use, and if the user role does not have access to the field in your measure, the metrics may show up as null!
In fact this is the most important point to check in my opinion, please check in detail if you have these settings in your model
5. Check if your measure may have specific access rights set up, without being granted permission to view these metrics, then these metrics will also show up as null in PowerBI.
Ensure that the account you are using in PowerBI has sufficient permissions to access and read all relevant data and metrics in the SSAS model. Insufficient permissions may result in a situation where you cannot see the data

If possible, could you provide more screenshots of the hidden private information, which would help to identify the problem.
Looking forward to your reply

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

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

I've now experimented a bit: If I build a new measure on an existing column, values are displayed in PowerBI.

If I now create a new column in the underlying database table and create a new measure in SSAS with this column, then the measure in PowerBI is empty. Is it possible that I need to introduce new relational attributes to PowerBI first? And if the answer is yer: How do I do that?

Thanks a lot!!!