Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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
Proud to be a Super User!
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
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
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.
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
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?
Proud to be a Super User!
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.
To help close this thread, you could accept your solution above. Your contribution is highly appreciated.
You may add ALL ( districtes[district] ) and ALL ( index[Council name] ) filters to CALCULATE Function.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |