Forum Discussion

Dunner2020's avatar
Dunner2020
Post Prodigy
5 years ago

using summarize table columns in filter statement

Hi there,   I am using summarize function to calculate the temporary table and then I want to calculate the rows count of that based on some condition. So I have written measure as follow:   Meas...
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
5 years ago

Dunner2020 , In the temp table I can see [Actual Event Start Time] not [Actual Event Start Time (NZST)]

why single quotes 'tempTable ' ? why not 'tempTable 

 

Can you please check that.

 

Why this can not be done without summarize?

 

You can use filter while adding data to summarize

 

example

SUMMARIZE(FILTER('Table',
Table[Actual Event Start Time (NZST)] >= [Current_RY_Yr_Strt] &&
'Table'[Actual Event Start Time (NZST)] < [Next_RY_Yr_Strt] &&
'Table'[ActualEvent Start Time (NZST)]<=Today() &&
'Table'[EventType]="3" && 'tempTable '[Status]="1"))