Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
matheus_mk0
Frequent Visitor

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:

matheus_mk0_0-1704646039791.png

 

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.

 
1 ACCEPTED SOLUTION
Idrissshatila
Super User
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.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

3 REPLIES 3
Ashish_Mathur
Super User
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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Idrissshatila
Super User
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.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




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!

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.