Forum Discussion
Default Date With Calculation Group
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.
My point was that if I change this to single select then the calculation group doesn't work anymore (because by default single select "forces" you to select any date)... do you have an idea how can we make this calculation group with a default date work with a single select?
Do you mean your default date range is a single date (e.g. the last date in fact table) and you want to have another date slicer for user to pick a single date? The whole page should reflect data on a single date (either the selected one or the default one)?
Yes, exactly! Would it be possible?
To be honest, it's the first time I use calculation group so I'm not sure at present. I need some time to test it. Thanks for your understanding. I will update here if have any idea.