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.
Hello,
I have a data table containing among other a timestamp, a numerical data value, and a data type:
The data is displayed in a report:
In the "Calibration" drop down menu you can see the three present datatypes. Notice the black curve over the red/green bar graph. This is data of datatype temperature, which is shown using the following DAX measure:
Supply temperature = calculate( selectedvalue( 'Data'[value] ), 'Data'[unittypeinputid] = 1511 )
What I would like to do is to always show the temperature curve no matter what datatypes are selected i the "Calibration" menu.
I know there are ways to control filter context using the filter pane and DAX filter functions, but after several hours of researching and experimenting I haven't been able to crack this nut. Any help is appreciated.
Thanks in advance, Mike
Solved! Go to Solution.
Supply temperature =
calculate(
selectedvalue( 'Data'[value] ),
'Data'[unittypeinputid] = 1511,
ALL( 'Data'[datatype] )
)
Supply temperature =
calculate(
selectedvalue( 'Data'[value] ),
'Data'[unittypeinputid] = 1511,
ALL( 'Data'[datatype] )
)
It works exactly as it should! @Anonymous Thanks for helping me out on this. Now comes the harder part, figuring out *how* it works...
I have the book, I am just not through all of its 740 pages yet 🙂 Again, thanks for your help and time.
or:
Supply temperature =
calculate(
selectedvalue( 'Data'[value] ),
'Data'[datatype] = "temperature"
)
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |