Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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!
User | Count |
---|---|
13 | |
8 | |
8 | |
7 | |
5 |
User | Count |
---|---|
23 | |
15 | |
15 | |
10 | |
7 |