Forum Discussion
how to calculate return
Hi, all
I wonder why this is error
1EA = CALCULATE(count('Table'[itemlv2_lastlinkconsumerid]), 'Table'[dvc_total] = 1)
I want to show the number of devices by Device Type (=n_combination) in a table as shown below.
However, if you generate the measure value in the above equation, there will be an error occurs.
dvc_total is also a measure value.
I would appreciate it if you could let me know how to get it.
Hi Anonymous ,
Here are the steps you can follow：
1. Create calculated column.
total = var _table=SUMMARIZE('Table','Table'[Id],'Table'[Dvcgroup],'Table'[n_combination],'Table'[cnt]) return SUMX(FILTER( _table,[Id]=EARLIER([Id])&&[n_combination]=EARLIER([n_combination])),[cnt])2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
3 Replies
- Greg_Deckler
Community Champion
Anonymous You cannot use a measure directly in the filter parameter of CALCULATE, you have to wrap it with FILTER like:
1EA = CALCULATE(count('Table'[itemlv2_lastlinkconsumerid]), FILTER('Table','Table'[dvc_total] = 1))
Hi Anonymous ,
Here are the steps you can follow：
1. Create calculated column.
total = var _table=SUMMARIZE('Table','Table'[Id],'Table'[Dvcgroup],'Table'[n_combination],'Table'[cnt]) return SUMX(FILTER( _table,[Id]=EARLIER([Id])&&[n_combination]=EARLIER([n_combination])),[cnt])2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
