The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I am trying to create a measure that will display a max value from a column of temperatures within a space but I keep getting an error for duplicate values when using the max function. This table is utelizing data from azure data explorer and is constantly updating. How would I write a measure to display just the highest value from a column on a card without getting this error? The following is an example of the table:
Location | Heat Index |
heat index 1 | 85 |
heat index 2 | 82 |
heat index 3 | 84 |
heat index 4 | 85 |
heat index 5 | 84 |
Solved! Go to Solution.
Hi,
this should work:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi,
this should work:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
User | Count |
---|---|
24 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
31 | |
12 | |
10 | |
10 | |
9 |