The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
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?
Solved! Go to Solution.
Hi @Rallmo try measure
Count_True = COUNTROWS(FILTER(ALL(AssetApplicationList), [Verified based on slicer] = TRUE))
Did I answer your question? Kudos appreciated / accept solution!
Proud to be a 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!
Proud to be a Super User!