Forum Discussion

J94's avatar
J94
Icon for Advocate II rankAdvocate II
1 year ago
Solved

Measures in different dataset not visible

Hello everyone,   I have a sales dataset with some measures. For instances Sales value, which is the sum of the column Sales[Sales]. I also have a MTD measure for sales, and the formule is Sales va...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi J94,
    Thanks for followup

    It looks like the issue is coming because the Sales table has been imported into the "4 bucket" report. When we use Import mode instead of a Live connection or DirectQuery, Power BI breaks the connection lineage with the original dataset. Because of this, some measures like MTD Month-To-Date or other time intelligence functions may not work properly when used with date fields. This is why your MTD value is only working when you don't add date columns in your visuals.

    To fix this, I suggest  these two options:
    Use DirectQuery mode and connect to the Sales dataset directly, so the model can understand the relationship and time functions work correctly. Or, if Import mode is required, you may need to re-create the logic manually using DAX filters and calculations.

    Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
    Best Regards,
    Harshitha.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi J94,
Thanks for followup

It looks like the issue is coming because the Sales table has been imported into the "4 bucket" report. When we use Import mode instead of a Live connection or DirectQuery, Power BI breaks the connection lineage with the original dataset. Because of this, some measures like MTD Month-To-Date or other time intelligence functions may not work properly when used with date fields. This is why your MTD value is only working when you don't add date columns in your visuals.

To fix this, I suggest  these two options:
Use DirectQuery mode and connect to the Sales dataset directly, so the model can understand the relationship and time functions work correctly. Or, if Import mode is required, you may need to re-create the logic manually using DAX filters and calculations.

Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
Best Regards,
Harshitha.

J94's avatar
J94
Icon for Advocate II rankAdvocate II
1 year ago

Hi Anonymous 

Thanks for your explanation. I've come to the same conclusion. So I am going to use DirectQuery to resolve this issue. 

Thanks again and have a nice day