Multiple Metric by Row

[spudrunner]

maybe fairly simple. Trying to create one visual, matrix possibly, similar to the one below. Two different measures, but need ability to add more. The #'s and %'s below are calculated measures based on other measures from the same table with different definitions. Trying to create one visual that'll allow me to have each measure and the calculated # and it's defined % on each row. 

	Count	%
At-Screen Risk	35343	.98
Referral	3598	.49

Came close with this, but it appears this is a table and can't be filtered by my different slicers..so apparently I need to have this in a measure somehow? Any help is appreciated. Thank you.

Custom Table =

union(

row("Measure","At-Screen Risk","Count",[Risk_Positive_Count],"%",[At-Screen Risk Positive %]),

row("Measure","# Referral", "Count",[Referral_Count],"%",[Referral %])

)

[Anonymous]

Hi @spudrunner ,

Based on the information you provided, as you said, it is not possible to filter with a different slicer since this is a table.
This allows the slicer to act on the matrix:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

^{Best Regards,}

^{Ada Wang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}

[spudrunner]

Thanks so much for your response. I see that the slicer is indeed controlling the matrix, but how do I get this in the format below, without the duplicated column/row headers? Thanks again.

[spudrunner]

The "measures" should probably read 'Referrals' and 'Students at-Risk', then have their corresponding #'s and % calculations as columns. But each measure will have a different # and % calculation, and the ability to add more measures on each row.

[spudrunner]

thank you. Below is a link to my test PBIX. I would like the table to look like the visual, but have it respond to the slicer. Thank you.

https://drive.google.com/file/d/1xd5u_yJRzAVd8mfBfEQVdewk-qE4wNIp/view?usp=drive_link

[Ritaf1983]

Hi @spudrunner 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523