topic Re: max value of measure (not a column from table) and count of this measure with threshold defined in DAX Commands and Tips

max value of measure (not a column from table) and count of this measure with threshold defined

reynold522 — Mon, 05 Dec 2022 16:44:45 GMT

Hi all,

I have a lot of IoT devices. which uploaded voltage value with sample rate 1 minute into cloud.

raw table will be like following:

then a summerized Table will be like following:

I create a measure to get duration with voltage<3V (min) accumulated.

then If I put table visualization with this measure combine with IoT ID

then it will like following in Power BI

I would like to write Dax code to get two value in the table above:

1. count number of row with duration >3 min: 2 in this case

2. max. value of duration: 4 in this case

Thanks in advance

Best regards

Renhao

Anonymous — Mon, 05 Dec 2022 13:36:27 GMT

1.max = MAX('Table'[vtg])

2. Count rows = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[vtg]>=1))

Output:

Best Regards,
Shreya Mukkawar

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

reynold522 — Mon, 05 Dec 2022 13:48:15 GMT

Hi Shreyamukkawar,

Thank you for the fastest speed to answer my question.

I may not explain my question clearly.

The table is a visualizations table from power BI. it is not a real table in Power BI Field.

Visualizations table is a result, accumlulated duration (hour) is asgined for each IoT ID and show as table in Power BI

The max function wont work as there is no table, no column.

However, Still thanks