Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have two measures :
Hi @Dwivedi15
The issue with the BudgetMeasure_HD disappearing might be due to incorrect data in the Source column, filters, or slicers affecting the measure. Ensure that both "Actual" and "Budget" values are properly populated in the Source column of the combined table. Check that the union of the "Actual" and "Budget" data is working correctly and that the correct rows are being combined. Test the measure in simpler contexts (e.g., without slicers) to rule out filter-related issues. Additionally, clear the cache and refresh the model to address any caching problems.
I think I did it
- While this data was getting merged in transformation- Date was treated as text and not Date, therefore all the data of Date field after refresh beacuse of BI Service- was overwritten as text ( Although in DAX I converted that filed into date - using normalisation of the filed and created new column) , which then telling that model to treat date as MM/DD/YYYY instead of DD/MM/YYYY.
Hi, @Dwivedi15
It looks like you have found a solution. Could you please mark this helpful post as “Answered”?
This will help others in the community to easily find a solution if they are experiencing the same problem as you.
Thank you for your cooperation!
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I think I did it 🙂 - While this data was getting merged in transformation- Date was treated as text and not Date, therefore all the data of Date field after refresh beacuse of BI Service- was overwritten as text ( Although in DAX I converted that filed into date - using normalisation of the filed and created new column) , which then telling that model to treat date as MM/DD/YYYY instead of DD/MM/YYYY.
Hi, @Dwivedi15
Could you tell me what’s your data connection mode (import, live connect or direct query) ?
May I ask if the DAX provided by nilendraFabric has solved the problem you are experiencing?
According to your description, You can check to see if there are any filters applied to your report or visualization charts that may affect the budget measure. sometimes filters can inadvertently exclude data.
Otherwise, would you like to share a sample pbix file you used(without sensitive data) and we can help you in advance.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi, there are no Filters in transformations when data is brought into the system - Table A and B are coming as it is in the system.
Then I am making a Combined table :
I think I did it 🙂 - While this data was getting merged in transformation- Date was treated as text and not Date, therefore all the data of Date field after refresh beacuse of BI Service- was overwritten as text ( Although in DAX I converted that filed into date - using normalisation of the filed and created new column) , which then telling that model to treat date as MM/DD/YYYY instead of DD/MM/YYYY.
Hello @Dwivedi15
Try adding an ALL() function to your measure to ignore any potential conflicting filter contexts:
BudgetMeasure_HD =
CALCULATE(
SUM(CombinedTable[Amount]),
ALL(CombinedTable),
CombinedTable[Source] = "Budget"
)
please see if this works, else we will look for other workarounds.
thanks
Hi I tried this :
Use ALLEXCEPT to preserve important filters:
Instead of using ALL, which removes all filters, try ALLEXCEPT to preserve date filters:
BudgetMeasure_HD =
CALCULATE(
SUM(CombinedTable[Amount]),
ALLEXCEPT(CombinedTable, CombinedTable[Date]),
CombinedTable[Source] = "Budget"
)
I think I did it 🙂 - While this data was getting merged in transformation- Date was treated as text and not Date, therefore all the data of Date field after refresh beacuse of BI Service- was overwritten as text ( Although in DAX I converted that filed into date - using normalisation of the filed and created new column) , which then telling that model to treat date as MM/DD/YYYY instead of DD/MM/YYYY.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
19 | |
15 | |
13 | |
11 | |
9 |
User | Count |
---|---|
25 | |
22 | |
12 | |
11 | |
10 |