Forum Discussion
Measure not filtering when filters are applied
, first time here,
So i wrote a simple measure, that counts rows apling some simple filters, and placed on a table. However, I want to be able to filter dates using a visual "filter".
I placed the visual "filter" on the project, but when i apply the filter, it doesn't affect the table
Ideas?
Here the measure that i wrote:
contas 1º aporte =
CALCULATE (
COUNTROWS ( 'Base BTG' ),
'Base BTG'[1º Aporte],
'Base BTG'[Aportes] >= 50000,
Originador[Originador] = "sacre digital"
|| Originador[Originador] = "sacre aai"
)
The date that i want to filter is on the 'Base BTG'[1º Aporte].
Here's a print of of the project:
Obs.: just to emphasize, i want the filter to affect the column "Contas Ativadas". As it is right now, the collumn has the content of all dates.
Hello matheus_mk0 ,
does the table that has the date have a relationship with the table that has the values you want to filter?
because if there's a relation then it should filter.
3 Replies
- Idrissshatila
Super User
Hello matheus_mk0 ,
does the table that has the date have a relationship with the table that has the values you want to filter?
because if there's a relation then it should filter.
- So i was using a separeted table to agregate all measures, and didn't know how to make a connection bettwen then. It was solved just moving the home table as part of dataset. Thank you very much!
- Ashish_Mathur
Hi,
Simplify your measure to this
contas 1º aporte = CALCULATE(COUNTROWS ( 'Base BTG' ),'Base BTG'[Aportes] >= 50000,(Originador[Originador] = "sacre digital"|| Originador[Originador] = "sacre aai" ))Also, create a Calendar Table and build a relationship (Many to One and Single) from the Date column of your Data Table to the Date column of the Calendar Table. To your slicer, drag Date from the Calendar Table.
Hope this helps.
