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

View all the Fabric Data Days sessions on demand. View schedule

Reply
OD_MADOLO
Frequent Visitor

count months with transactions above 1

 

Hi All

 

I have a simple count measure that counts if in a month the same goods have been paid for twice and if not to hide it. 

 

CountAmount = if(COUNT(AP_DUPLICATE_SUPPLIER_GOODS_VW[AMOUNT_PAID])=1,BLANK(), COUNT(AP_DUPLICATE_SUPPLIER_GOODS_VW[AMOUNT_PAID]))
 
then I place the measure in matrix and this is what I get below 
OD_MADOLO_0-1626800150778.png

Now I need to take this a step further by only showing suppliers that have transactions for 6 months and above.

The ones I have circled in red are just an example of what I need to omit.

Thanks

 

Please let me know how best to go about this:

 

KR
T

1 REPLY 1
DataInsights
Super User
Super User

@OD_MADOLO,

 

Is the requirement for 6 months in the current year or all time? Would you be able to provide a link to your pbix with sample data? If not, please provide sample data that can be copied to Power BI.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors