Forum Discussion
Post ProdigyMeasure does not calculate all values
Hi there,
I have got event data. I have a measure that calculates the sum of the min column and divides it by a certain number.: Measure looks as follows:
I have plot the measure as follow:
However, it does not calculate the value for all areas. For example, as highlighted in red color 'Anderson Bay' area value shown in figure is 0. However, in actual it should be 5.xxxxx. I have attached the sample file here. Could anyone help me where I made the mistake?
Hi, Dunner2020
Accoring to your description, You need to modify your measure.
Like this:
Measure 2 = SUMX(FILTER('Table',NOT('Table'[EventType]=3&&YEAR([Cancelled Date (NZST)])>1900)),[TotalConsumerMinutes]/91577)If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
Dunner2020 , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Try formula like
Measure =
Var cancel_date = MaxX(all('Table'),'Table'[Cancelled Date (NZST)])
Var _type = MAX('Table'[EventType])
RETURN
IF(YEAR(cancel_date)>1900 && _type = 3,0,
CALCULATE (
SUMX ( 'Table',
([TotalConsumerMinutes])/91577
)))
Dunner2020amitchandak I have attached the sample file in the original post.
- v-janeyg-msft
Community Support
Hi, Dunner2020
Accoring to your description, You need to modify your measure.
Like this:
Measure 2 = SUMX(FILTER('Table',NOT('Table'[EventType]=3&&YEAR([Cancelled Date (NZST)])>1900)),[TotalConsumerMinutes]/91577)If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
