topic Re: Countrows based on filtered measure type text in DAX Commands and Tips

Countrows based on filtered measure type text

Kebas_Leech — Thu, 08 Sep 2022 13:46:52 GMT

Hello Everyone,

I have been trying to solve this but i've been unsuccessful so far.

The following measure [perf_shift] calculates and prints in which shift i have the max performance, based on another measure [performance]:

VAR vals = SUMMARIZE( 'Main_Table', 'Main_Table' [Shifts], "Measure", [performance] ) VAR measureMax = MAXX( vals, [performance] ) VAR perf_shift = CALCULATE( MAXX( FILTER( vals, [Measure] = measureMax ), 'Main_Table' [Shifts] ) ) RETURN perf_shift

Returns: (filter: Production Line and Product Type)

Production Line	Product Type	Perf_Shift
1	type x	1st
1	type y	1st
1	type z	1st
2	type y	2nd

Now, what im trying to calculate is the total sum of 1st and 2nd shifts that I end up with based on the same filters.

Expected Result:

Shift	Count
1st	3
2nd	1

Thank you!

Re: Countrows based on filtered measure type text

amitchandak — Thu, 08 Sep 2022 13:59:27 GMT

Kebas_Leech , You need to do dynamic segmentation

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

Above is for single value what you need

range value example

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626

Re: Countrows based on filtered measure type text

tamerj1 — Thu, 08 Sep 2022 14:06:59 GMT

Hi Kebas_Leech

you need first to creat a disconnected table that contains { "1st", "2nd" } let's call it Shifts which you're going to use in the visual

then use the following measure

Count = SUMX ( SUMMARIZE ( 'Main_Table', 'Main_Table'[Production], 'Main_Table'[LineProduct] ), IF ( [Perf_Shift] = MAX ( Shifts[Shift] ), 1 ) )

Re: Countrows based on filtered measure type text

Kebas_Leech — Sun, 11 Sep 2022 14:22:25 GMT

Both replies helped. Thank you so much!