Selected value table

[jaltoft]

Hello can anyone please help me?

I have the following table visual which I intend to sit as shown below -

The data from this comes from at table structured like as below. (More headings than KSI and VTI this is demo and demo data)

Reporting Month	Region	KSI	VTI
Jun-23	East	45	545
Jun-23	Midlands	3479	454
Jun-23	North West	34	454
Jun-23	South East	76	65
Jun-23	YNE	45	56
Jun-23	South West	34	56
Jun-23	National	2445	45

As I want my data to look like the below in the table I have so far created a bridging table of sorts as I needed the data from my original table named Data feed and the headings in the order I wanted them.

And a variable

KSI 1 =

VAR selectedcategory=ALLSELECTED('Data feed'[Region])

RETURN

CALCULATE([KSI Total],FILTER('Data feed','Data feed'[Region]=selectedcategory))

Now this all works including the slicers apart from the issue is I need the value in the KSI 1 for example to be blank when it is not that Metric and not repeated. I have 2 slicers on the page reporting date and Region both come from from the Data feed table. Can anyone help??

[jaltoft]

Thanks @lbendlin for reply

So my table called Data feed bridging table looks like this -

So I want to be able to slice my table by region and date (Only been able to include one month).

But at the moment its working fine but the values are repeating on each metric as above picture in first post when I only want them to show in the measure in the column and if not blank.

Metric number	Measure groups	Metric	Weighting
1	VTI	KSI	10.00%
2	FIN	Lost Time Injury (LTI)	10.00%
3	LESS	LTI	10.00%
4	RTN	% cleared within 1 hr	10.00%
5	Correspondence	SRUS	2.50%
5	BELL	Correspondence	2.50%
5	Complaints	Roadworks information	2.50%
5	Corporate Carbon	Complaints	2.50%
6	Biodiversity Units added	Corporate Carbon	5.00%

This is the data feed table

Reporting Month	Region	VTI	FIN	LESS	RTN	Correspondence	BELL	Complaints	Corporate Carbon
01/06/2023	East	241	0	0.56	0.72	0	0.902	34	34
01/06/2023	Midlands	219	0	0.16	0.73	0	0.7	0	0
01/06/2023	North West	1000	0	0.26	0.76	0	0.903	354	34
01/06/2023	South East	158	0	0.07	0.69	0	0.797	0	0
01/06/2023	YNE	413	0	0.28	0.77	0	0.999	0	0
01/06/2023	South West	131	0	0.26	0.8	0	0.786	45	0
01/06/2023	National	126	0	0.3	0.89	0	0.701	0	44

[lbendlin]

Please include all required details - what is your calendar table looking like, and what is your expected outcome?

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data 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.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...