Create measure to group

[gelsonwj]

I would like to create a measure to group only the varieties that belong to the group where harvest_name = 2021/2022

[FreemanZ]

hi @gelsonwj 

Are you expecing a measure like this?
Count =CALCULATE(COUNT(TableName[variety_name]), TableName[harvest_name] = "2021/2022")

[gelsonwj]

No, I would just like that when placing the measurement in the table, only the lines where "varieti_name" belongs to "harvest_name" = 2021/2022 would appear

[FreemanZ]

hi @gelsonwj 

Why not do it simply with a slicer or filter pane setting?

[amitchandak]

@gelsonwj ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

segmentation can help

https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
https://youtu.be/CuczXPj0N-k

https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-po...

Appreciate your Kudos.

[gelsonwj]

i would like to have a table with columns "name", "farm_name" and "variety_name", but with the condition that the values ​​of "variety_name" are only where "harvest_name" = 2021/2022. I would like to have a measure that makes this grouping of selecting only the lines of the "variety_name" column where "harvest_name" = 2021/2022.