Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
, 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.
Solved! Go to Solution.
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.
Proud to be a Super User! | |
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.
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.
Proud to be a Super User! | |
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
116 | |
99 | |
87 | |
35 | |
35 |
User | Count |
---|---|
152 | |
98 | |
81 | |
61 | |
55 |