using 3 difrent values/filters of the same measurement in the same visual

[ovie]

I created a measurement and I want to use the result values ​​of the measurement with 3 different filters (all values, all values ​​by filter 1 and all the values ​​for filter 2).

There is a different value for each filter, and a total of 3 values ​​that I want to display in the same gauge visual.

Any ideas how do you do this ??? I have 15 measurements I made...

This page is supposed to be dynamic and need to changed acourdind to the selected on thr slicers (some of the values will stay the same).

here is  an example file

https://drive.google.com/file/d/0B6nJkTSj2exsS2FGOVJqNldwSW8/view?usp=sharing

[richbenmintz]

@ovie

Are you able to upload your pbix file and an example of your desired results? would really make providing a solution much easier.

Thanks,

Richard

[ovie]

thanks for trying to help,

This page is supposed to be dynamic and need to changed acourding to the selected on thr slicers (some of the values will stay the same).

here is  an example file

https://drive.google.com/file/d/0B6nJkTSj2exsS2FGOVJqNldwSW8/view?usp=sharing

[Greg_Deckler]

I would think that you would create four additional measures.

MeasureAll = CALCULATE([Measure],ALL(Table))
MeasureFilter1 = CALCULATE([Measure],FILTER())
MeasureFilter2 = CALCULATE([Measure],FILTER())
MeasureSum = [MeasureAll]+[MeasureFilter1]+[MeasureFilter2]

Your filter clauses will be different obviously.

Can't be more specific without some additional information.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[siddhartha0208]

In Cases where we used to use in

SQL: SELECT SUM([SumField]) as Measure1 FROM [table] WHERE [FilterField] IN ('Value1','Value2','Value3','Value4')

DAX would work like Measure1 = CALCULATE(SUM(table[SumField]), FILTER(table,OR(OR(OR(table[FilterField] = "Value1",table[FilterField] = "Value2"), table[FilterField] = "Value3"), table[FilterField] = "Value4")))))

Similar nesting would work for AND operator as well. DAX AND and OR operators can only take 2 logical statements to calculate.

[ovie]

thanks for trying to help out, but I donw think this will help.

This page is supposed to be dynamic and need to changed acourdind to the selected on thr slicers (some of the values will stay the same).

Here is an example file:

https://drive.google.com/file/d/0B6nJkTSj2exsS2FGOVJqNldwSW8/view?usp=sharing

[richbenmintz]

Hi @ovie

you have hard coded some constants in your measure definition in your sample file. will those values always be constant or are they supposed to be sliceable? 

[ovie · Accepted solution]

Thanks for your reply, It's sopuse to be sliced.

I soled by creating 2 more tables wuth calculated colums.

This did the job but was a lot of time and work.

If there is another elegant solution to solve it, I will be happy to learn.

[v-chuncz-msft]

@ovie,

To help close this thread, you could accept your solution above. Your contribution is highly appreciated.

[v-chuncz-msft]

@ovie,

You may add ALL ( districtes[district] ) and ALL ( index[Council name] ) filters to CALCULATE Function.