min,avg,max measure with measure as filter

[RhoFox]

Hi There 🙂

I need struggle with some measure in this case:

I have this table:

Project	Pos	Value
Project 1	111	4
Project 1	112	5
Project 1	113	6
Project 1	114	7
Project 1	115	8
Project 2	111	9
Project 2	112	1
Project 2	113	2
...	...	...

I have a lot of filter/slicer in my dashboard, for example:

Project = Project 1 or Project 2

I have some True/False Measure "Select" with some callculation behind

Project	Pos	Value	Select
Project 1	111	4	True
Project 1	112	5	True
Project 1	113	6	True
Project 1	114	7	True
Project 1	115	8	False
Project 2	111	9	False
Project 2	112	1	False
Project 2	113	2	True
Project 2	114	3	True
Project 2	115	5	True

I need now 3 Measures:
min, avg and max from the values, it must be filteret and has to ignore the False values from the Measure "Select"

Serched:
Min = 2
Avg = 4.57
Max = 7

I would be very grateful for any help 🙂
Here is the Wetransfer Link to the pbix:
https://we.tl/t-o7wkH0Rlxn

[v-luwang-msft · Accepted solution]

Hi @RhoFox ，

The data you provided and the pbix file have a little different,so result will have a little different.

Try the following measure:

mintest = CALCULATE(MIN(Tabelle11[Value]),FILTER(ALLSELECTED(Tabelle11),[Select]="True"))

maxtest = CALCULATE(MAX(Tabelle11[Value]),FILTER(ALLSELECTED(Tabelle11),[Select]="True"))

average = CALCULATE(AVERAGE(Tabelle11[Value]),FILTER(ALLSELECTED(Tabelle11),[Select]="True"))

Final get the below:

Wish it is helpful for you!

Best Regards

Lucien

[lbendlin]

the link may have expired?