Forum Discussion
Default Date With Calculation Group
Hello,
I am trying to create a default date in the Power BI report with the help of this video:
https://www.youtube.com/watch?v=KBEsPGxDxHM
I want the report to be showing by default the most recent (max) Report Date (fact Orderbook table).
This is the calculation I have created based on the above video:
VAR _IsDateFiltered =
CALCULATE ( ISFILTERED ( 'dim Calendar'[Date] ), ALLSELECTED () )
VAR _LastReportDate =
CALCULATE ( MAX ( 'fact Orderbook'[Report Date] ), REMOVEFILTERS () ) + 1
VAR _Days = 7
VAR _Result =
IF (
_IsDateFiltered,
SELECTEDMEASURE (),
CALCULATE (
SELECTEDMEASURE (),
KEEPFILTERS ( DATESINPERIOD ( 'dim Calendar'[Date], _LastReportDate, -1, DAY ) )
)
)
RETURN
_Result
However, when I select the "Recent" from the slicer, nothing is changing... What am I doing wrong?
Hi Anonymous
I followed the video and created a sample for your reference. You can download it at bottom.
I guess if you drag columns directly into visuals as values fields? If so, when a model has calculation groups, the implicit column aggregations will fail. Implicit column aggregations in Power BI are not supported for models with calculation groups. This is by design. See Tabular Editor - Calculation groups - Microsoft Power BI Community
As a result, when you include a calculation group in this model, you need to create measures to aggregate columns. Then put them into visuals as values fields.
E.g. in my sample, Close Total is a simple measure SUM('FactTable'[Close]). In below image, you will find that the table having Close Total can be filtered by the Default Dates slicer, but the table having Close column cannot be filtered. If you right click on the Close column in Values card of the table visual, you will find that there are no aggregate types to select in its right-click menu.
Let me know if you have any questions.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
9 Replies
Hi Anonymous
I followed the video and created a sample for your reference. You can download it at bottom.
I guess if you drag columns directly into visuals as values fields? If so, when a model has calculation groups, the implicit column aggregations will fail. Implicit column aggregations in Power BI are not supported for models with calculation groups. This is by design. See Tabular Editor - Calculation groups - Microsoft Power BI Community
As a result, when you include a calculation group in this model, you need to create measures to aggregate columns. Then put them into visuals as values fields.
E.g. in my sample, Close Total is a simple measure SUM('FactTable'[Close]). In below image, you will find that the table having Close Total can be filtered by the Default Dates slicer, but the table having Close column cannot be filtered. If you right click on the Close column in Values card of the table visual, you will find that there are no aggregate types to select in its right-click menu.
Let me know if you have any questions.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.Hello,
I have exactly the same problem just like the first person described it. I have implemented the solution you recommended by creating a simple measure and putting it into visuals as values fields but it is not still working. Do you recommend I do any other thing to resolve it?
One more thing here - sorry. I have noticed that it works perfectly fine when we have a slicer that allows multiple selections.
How can I make it work with a single-select slicer?
Anonymous You can switch the slicer to single select mode in Format pane. Under Selection controls > Single select.
