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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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