Forum Discussion
Count values that equal to Maximum per category.
- 2 years ago
Hello Jianpeng Li, thank you very much for your help.
It worked on the data I sent but it did not work on my original data.
I must have made a mistake in my original measure that I shared.
Anyway I was able to come up with a different approach that worked.
For anyone interested see measure below.
MEASURE =
VAR _max_table =
SUMMARIZE (
ALLSELECTED ( 'Table 2' ),
'Table 2'[category_1],
'Table 2'[category_2],
"max_evaluation", CALCULATE ( MAX ( 'Table 2'[evaluation] ) )
)
VAR _values =
SELECTCOLUMNS (
'Table 2',
"category_1", 'Table 2'[category_1],
"category_2", 'Table 2'[category_2],
"evaluation", 'Table 2'[evaluation]
)
VAR _inter =
INTERSECT ( _max_table, _values )
RETURN
COUNTROWS ( _inter )
Hello Jianpeng Li, thank you very much for your help.
It worked on the data I sent but it did not work on my original data.
I must have made a mistake in my original measure that I shared.
Anyway I was able to come up with a different approach that worked.
For anyone interested see measure below.
MEASURE =
VAR _max_table =
SUMMARIZE (
ALLSELECTED ( 'Table 2' ),
'Table 2'[category_1],
'Table 2'[category_2],
"max_evaluation", CALCULATE ( MAX ( 'Table 2'[evaluation] ) )
)
VAR _values =
SELECTCOLUMNS (
'Table 2',
"category_1", 'Table 2'[category_1],
"category_2", 'Table 2'[category_2],
"evaluation", 'Table 2'[evaluation]
)
VAR _inter =
INTERSECT ( _max_table, _values )
RETURN
COUNTROWS ( _inter )
Hi, dvavrous
Thank you very much for your reply. Did the DAX expression you shared solve your current problem?
Best Regards
Jianpeng Li