time intelligence quick measure problem

Question

I have been having a significant issue with time intelligence quick measure function which I can't seem to find a way to fix .

I have been continuously getting that error saying " time intelligence quick measure can only be grouped or filtered by the power bi provided date hierarchy or primary date column" despite my date on date dimension is set up in a hierarchy .

autodate function in the power bi main option was already on.

I have tried a few things after googling

1. tried to set the date dimension table as " mark as date table" and nominated the " date" column to be the date. however this screwed up all my visualisations and I had to start from the beginning basically.

2. I tried to make a new table with a date, year,month and day all in separate column with hiearachy and created a relationship with the sale fact table to see if that worked and the visualisation just looked weird . It didn't seem to make sense. I am not sure what I am doing wrong 😞

Would really appreciate if someone could help!

vahiddm · Answer

Hi&nbsp;Anonymous&nbsp;&nbsp;According to your DAX code ISFILTERED([Date]), Did you set any filter on your Date column?Appreciate your Kudos!!

anonymous · Answer

No, no filters applied&nbsp;

vahiddm · Answer

Can you swap the True and False codes in the IF formula and check that again?Is it possible to share the PBIX file [after removing the sensetive data]?&nbsp;Appreciate your Kudos!!&nbsp;

anonymous · Answer

I have tried removing IF filtered sentence and tried running it but the visual look quite iffy.I couldn't attach the file here so&nbsp;https://drive.google.com/file/d/11UCq-ZxQiOzeMqCBoIs8aroLqBJ7IApv/view?usp=sharing&nbsp;attached a link here but unsure if that can be accessed?

v-robertq-msft · Answer

Hi,&nbsp;
As far as I’m concerned, I think you can first try to create a calendar table to connect it to the main table, you can follow this link:
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
&nbsp;
You can also refer to this solution provided from the Power Bi support in a solved case:
https://community.powerbi.com/t5/Service/Time-intelligence-does-not-work/td-p/279520
&nbsp;
Thank you very much!
&nbsp;
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

time intelligence quick measure problem

5 Replies

Related content

Time Intelligence Quick Measures Problem

Measure formula problem

Dax measure for below problem

Logic problem?

Measure problem (problem with ALL)