topic Re: group and display values from a measure in DAX Commands and Tips

group and display values from a measure

jonassantos — Sun, 19 Feb 2023 15:25:10 GMT

I'm trying to sum the values of a column generated from a measure.
the totalBycodeAlpha column is the measure that I'm trying to create, in it I'm trying to sum the values of the value_calculated column (measure), grouped by the code-alpha column and display these values. But it turns out it's a lot harder than I thought...

does anyone know a way to solve this

link of project:
https://drive.google.com/file/d/14yUk7y-UfOY0f21ySWCqsGuctdVJMARM/view?usp=sharing

how i am trying to apply:

totalBycodeAlpha =

//total must sum the measure (value_calculated) by code_alphA

CALCULATE(

SUMX('base calculate',[maxValueOfProducts]),

ALLSELECTED('base calculate'),

FILTER('base calculate',

'base calculate'[code-alpha]=MAX('base calculate'[code-alpha]))

)

table with dataset

Re: group and display values from a measure

amitchandak — Mon, 20 Feb 2023 01:45:59 GMT

jonassantos , You need something like

CALCULATE(
SUMX('base calculate',[maxValueOfProducts]),
FILTER(ALLSELECTED('base calculate'),
'base calculate'[code-alpha]=MAX('base calculate'[code-alpha]))
)

or refer

Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee884e

Re: group and display values from a measure

jonassantos — Mon, 20 Feb 2023 03:19:04 GMT

thanks, realy very good the result.

topic Re: group and display values ​​from a measure in DAX Commands and Tips

group and display values ​​from a measure

Re: group and display values ​​from a measure

Re: group and display values ​​from a measure

topic Re: group and display values from a measure in DAX Commands and Tips

group and display values from a measure

Re: group and display values from a measure

Re: group and display values from a measure