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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Rallmo
Helper I
Helper I

Count number of True/False from a measure

Hi.
I want to count the number of True/False from the results of a measure. The measure is affected by my slicer "Months", so when I chose a number in the slicer the measure calculates based on the slicer choise. Maybe not super advanced stuff but I'm happy that I was able to solve that measure along with the slicer. But now that I would like to count the number of True/False from that same measure I'm stuck. 

Rallmo_0-1694697202741.png


This is my DAX where [NO Months] is my slicer input.

Verified based on slicer = 
VAR _max = 
MAX(AssetApplicationList[Last time verified])
VAR _ver = 
    IF(
        SELECTEDVALUE(AssetApplicationList[Last time verified]) < [NO Months],
        TRUE(),
        FALSE()
    )
RETURN
_ver

 

I feel like I'm stuck in a loop where this is not dynamic enough to be used in a calculated column, but since there is no column that writes out the result of the measure its not static enough either.

 

Maybe the solution is easy, maybe its not but for now I don't se the path forward. Any ideas on how to solve this?

1 ACCEPTED SOLUTION
some_bih
Super User
Super User

Hi @Rallmo try measure

Count_True = COUNTROWS(FILTER(ALL(AssetApplicationList), [Verified based on slicer] = TRUE))

Did I answer your question? Kudos appreciated / accept solution!

 





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

Proud to be a Super User!






View solution in original post

2 REPLIES 2
some_bih
Super User
Super User

Hi @Rallmo try measure

Count_True = COUNTROWS(FILTER(ALL(AssetApplicationList), [Verified based on slicer] = TRUE))

Did I answer your question? Kudos appreciated / accept solution!

 





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

Proud to be a Super User!






Amazing, that worked like a charm!

Thanks @some_bih

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

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.