Need to show UCL and LCL for the multiple values of slicer

[Aradhana]

Hi All,

Below screenshot is the table from Postgres SQL database. 

Here Create_time, Measurement_description and Hose_cosket_crimp_type are three slicers in PowerBI report. 

Requirement: Line chart needs to pick the calculated UCL and LCL values from DB for the selections made in slicers.

Note:  Measurement_description is multi value selection, It is separated by comma in table.

For example:

1.If user selects, create_time as 24th May 2023 ,Hose_cosket_crimp_type as 3162-20-13562-F and Measurement_description as

a) Connection End Crimp Diameter,   

b)Hose End Crimp Diameter, 

c) Middle Crimp Diameter 

UCL and LCL values are  1.5762873211529267 and 1.5737773014885872 respectively.

2.If user selects, create_time as 24th May 2023 ,Hose_cosket_crimp_type as 3162-32-13562-E and Measurement_description as

a) Connection End Crimp Diameter,   

b) Middle Crimp Diameter 

UCL and LCL values are  2.3495509673044968 and 2.3465939602317443 respectively.

If we split the measurement description into separate rows in query editor like below, for the same day ,for the same Hose_cosket_crimp_type  and for all same measurement_description, it will sum up the UCL and LCL which I don't need.

How can I solve this.

Please help me.

Thanks,

Aradhana

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Aradhana]

Hi All,

Sorry for the inconvenience. 

Reposting the question by providing data in a usable format.

Below table is the UCL and LCL data from the database.

Requirement: Need to display UCL and LCL values in Line chart for the selection made in slicers.

Here there are 3 sclicers->  date, hose socket crimp type and measurement description.

There are 3 Measurement description values in slicer and it is multiselected->  Connection End Crimp Diameter, Hose End Crimp Diameter and Middle Crimp Diameter.

For example:

1.If user selects, create_time as 24th May 2023 ,Hose_cosket_crimp_type as 3162-20-13562-F and Measurement_description as Connection End Crimp Diameter,   Hose End Crimp Diameter, Middle Crimp Diameter 

UCL and LCL values are  1.5762873211529267 and 1.5737773014885872 respectively.

2.If user selects, create_time as 24th May 2023 ,Hose_cosket_crimp_type as 3162-32-13562-E and Measurement_description as Connection End Crimp Diameter, Middle Crimp Diameter 

UCL and LCL values are  2.3495509673044968 and 2.3465939602317443 respectively.

Problem is when user selects multiple measurement descriptions, It is summing up the individual measurement description instead of picking the combined measurement descriptions values.

Measure_UCLh =
var date_value=SELECTEDVALUE(date_table[Date])
var hs_value=SELECTEDVALUE(hose_socket_crimp_type[(hose_socket_crimp_type])
var md_value=CONCATENATEX(VALUES(measurement_description[(measurement_description]),[(measurement_description],", ")
return
CALCULATE(sum(historical_diameter[ucl]),
FILTER(historical_diameter,historical_diameter[create_time]=date_value&&
historical_diameter[hose_socket_crimp_type]=hs_value&&
historical_diameter[measurement_description] = md_value
))

lcl	ucl	create_time	measurement_description	hose_socket_crimp_type
1.573777301	1.576287321	5/24/2023 0:00	Connection End Crimp Diameter, Hose End Crimp Diameter, Middle Crimp Diameter	3162-20-13562-F
2.346220548	2.349717341	5/24/2023 0:00	Connection End Crimp Diameter, Hose End Crimp Diameter, Middle Crimp Diameter	3162-32-13562-E
1.573501867	1.576458478	5/24/2023 0:00	Connection End Crimp Diameter, Hose End Crimp Diameter	3162-20-13562-F
2.345410128	2.350089872	5/24/2023 0:00	Connection End Crimp Diameter, Hose End Crimp Diameter	3162-32-13562-E
1.573890199	1.576269363	5/24/2023 0:00	Connection End Crimp Diameter, Middle Crimp Diameter	3162-20-13562-F
2.34659396	2.349550967	5/24/2023 0:00	Connection End Crimp Diameter, Middle Crimp Diameter	3162-32-13562-E
1.573772441	1.576230291	5/24/2023 0:00	Hose End Crimp Diameter, Middle Crimp Diameter	3162-20-13562-F
2.346233886	2.349642925	5/24/2023 0:00	Hose End Crimp Diameter, Middle Crimp Diameter	3162-32-13562-E
1.573438576	1.576026941	5/24/2023 0:00	Hose End Crimp Diameter	3162-20-13562-F
2.345253933	2.349441719	5/24/2023 0:00	Hose End Crimp Diameter	3162-32-13562-E
1.573894872	1.576209024	5/24/2023 0:00	Middle Crimp Diameter	3162-20-13562-F
2.346683398	2.349429646	5/24/2023 0:00	Middle Crimp Diameter	3162-32-13562-E
1.573957535	1.576497638	5/24/2023 0:00	Connection End Crimp Diameter	3162-20-13562-F
2.346210332	2.350094016	5/24/2023 0:00	Connection End Crimp Diameter	3162-32-13562-E
1.573411982	1.576363719	5/18/2023 0:00	Connection End Crimp Diameter, Hose End Crimp Diameter, Middle Crimp Diameter	3162-20-13562-F
1.572746224	1.576653776	5/18/2023 0:00	Connection End Crimp Diameter, Hose End Crimp Diameter	3162-20-13562-F
1.573702499	1.576254023	5/18/2023 0:00	Connection End Crimp Diameter, Middle Crimp Diameter	3162-20-13562-F
1.573429151	1.57628824	5/18/2023 0:00	Hose End Crimp Diameter, Middle Crimp Diameter	3162-20-13562-F
1.572763529	1.575903138	5/18/2023 0:00	Hose End Crimp Diameter	3162-20-13562-F
1.57377478	1.576147298	5/18/2023 0:00	Middle Crimp Diameter	3162-20-13562-F
1.573378472	1.576754861	5/18/2023 0:00	Connection End Crimp Diameter	3162-20-13562-F

[lbendlin]

Problem is when user selects multiple measurement descriptions, It is summing up the individual measurement description instead of picking the combined measurement descriptions values.

How would "combined measurement description values"  look like? Is it sufficient to suppress the summarization?