This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 56.00000000000001%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
I m following the below article to create MTD, QTD and YTD (Time intelligence) calculation group in SSAS Tabular model in VS and then deploying it to Azure AS.
calculation group :
CALCULATE(SELECTEDMEASURE(), DATESMTD(DimDate[Date]))
CALCULATE(SELECTEDMEASURE(), DATESQTD(DimDate[Date]))
CALCULATE(SELECTEDMEASURE(), DATESYTD(DimDate[Date]))
https://devblogs.microsoft.com/premier-developer/dax-calculation-groups-for-time-intelligence/
The problem I m facing is that my visuals are not filtering .
My visuals on PowerBI Client dont load when I click on YTD or QTD or MTD slicer
I have star schema with 10 Dimensions and 1 fact sales table and a DimDate Table which has the the date and the datekey.
All my measures are in the fact table and have created around calculated 20 measures on top of it which are under measures folder but they don't sit under calculation groups .
Do I need to associate my calculated measures with the calculation group to ensure the slicers work?
DimDate table data
Visual studio version
Powerbi Version
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 1%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECF%3C/text%3E%3C/svg%3E)
Hi @Anonymous ,
If you click on "See details", what do you have as error message ?
Cedric
![
See the below error message
66563-image.png]1
The error message is weird.
I'm not sure that it's related to your calculations groups. After deploying in Azure AS, did you refresh you model successfully with SSMS for example.
Moreover, manage Calculation groups with VS can be hard sometimes. Using Tabular Editor remain the best option from my point of view.
Cedric
Yes, the deployment/processing is fine and the data does refresh. The problem is with the implementation of calculation group. Should I have calculated measures under another calculation group?
what do you mean by have a calculated measure under another calculation group ?
Your calculation group seems correct for me. nevertheless, i don't understand why the "ordinal" column is not visible in your screenshot.
if you completely remove the slicer on the calculation group in the report, do you have something display ?
what do you mean by have a calculated measure under another calculation group ?
Is there another way of creating the calculation group ? You can ignore this question .
I don't use Tabular editor and I think it is not from Microsoft .
The ordinal column has been renamed to Time Intelligence.
if you completely remove the slicer on the calculation group in the report, do you have something display ?
Yes ,I can see data If I remove slicer .
I don't use Tabular editor and I think it is not from Microsoft .
Even Microsoft recommand Tabular Editor when you need to manage Calculation groups in Power BI directly.
Can you try through SSMS a manual recalc of you model like below
and try again.
if it's not still working after that, i suggest you to recreate a new calculation group by using tabular editor.
Moreover, which version of VS and Power BI are you using
The SSMS processing worked but filters didn't work still, I have updated the versions of PowerbI and VS in the first post. I will try to recreate the calculation group again .
Can you put for eg one of measure use in your visual which is not correctly display with your calculation group.
one thing to do also can be to launch the Performance Analyzer from Power BI to get the Dax query ran over your model. it can be a way to find what it's not working in your model.
Regards
Cedric
Wow man ,Tabular editor is good it showed me the error message right upfront . Now I need to fix the syntax and then will see how it goes.
good for you, but it's strange that VS did'nt show any warning message about that. In general VS through a warning when you have syntaxic error in your DAX.
Even if, i don't see where it's the syntax error in your capture :( Unless you put an invalid table name.
Cedric
Now visuals load but the calculated measure is not returning data, I got this query out from Performance Analyzer . You can see I have a calculated measure which doesn't seem to return value with the MTD filter
// DAX Query
DEFINE VAR __DS0FilterTable =
TREATAS({"MTD"}, 'Time Aggregation'[Time Intelligence])
EVALUATE
SUMMARIZECOLUMNS(__DS0FilterTable, "PVA", IGNORE('PBI_FactAll'[PVA]))
Hi,
the result look strange. How is define your measure PVA ?
Regarding relationship between your dimension date and your fact table. do you have a complete set of dates in your date table ?
the result suggest that you don't have datas in PBI_FactAll matching with values returns by DATESMTD(PBI_DimDate[Date]).
Appreciate your help my friend. You truly are a genius AS guy
I built the table using the below link and it works fine now
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/