Forum Discussion
Count Rows Falling between two dates ( from disconnected table )
I still don't see an issue here
You need to display
'Table 1'[Created] and'Table 1'[Created +90] in the viz for the DAX to evaluate in the filter context. Without having that axis present, the expression will not evaluate.But if you do want to have that one displayed without bringing'Table 1'[Created] and'Table 1'[Created +90]then you need an index column and do this with a new measure
I added a category column into my data and this measure needs the lowest level (task number) to work.
it's not working as expected if I remove the task number.
the calculation should always work on task level and then aggregate per report context
Any way we can achieve this?
I get below; If I remove the lowest level and add category
I still don't see an issue here
You need to display
'Table 1'[Created] and'Table 1'[Created +90] in the viz for the DAX to evaluate in the filter context. Without having that axis present, the expression will not evaluate.But if you do want to have that one displayed without bringing'Table 1'[Created] and'Table 1'[Created +90]then you need an index column and do this with a new measureI think this is what the exact challenge is; to make this measure work without including task number or date (lowest level) into the viz.
I am using powerbi dataset, so I can't even make this work using the calculated column.
sagar512 when you are asking a question can you pleae make sure to include all the components? Do you wan to revise the previously provided sample data and include this new component?
Added the new column to the data (original post).