Want to show custom matrix table

[AshDil]

Hi,

I want to show the data in following custom matrix format

Category	Unit of Measure	Size	Jan	Feb
salt	Kg	Actual	40	60
	kg	Medium	50	70
	Kg	High	60	120
	%	Accuracy	67%	50%
Sugar	Kg	Actual	60	30
	Kg	Medium	90	90
	Kg	High	100	120
	%	Accuracy	60%	25%
Baking soda	Ton	Actual	30	50
	ton	Medium	50	70
	Ton	High	100	100
	%	Accuracy	30%	50%

The accuracy is Actual value divided by High value (eg: for month Jan, Category = "Salt", Actual value =  40 and High value = 60, so the accuracy  = 40/60 = 67%)

Please help me to do it.

Thanks,

AshDil.

[Greg_Deckler]

@AshDil What does your actual data look like?

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[AshDil]

Hi @Greg_Deckler ,

I have resolved the issue by myself. Thanks for your reply.

Thanks,

AshDil.

[Icey]

Hi @AshDil ,

Glad to hear that!

Could you share your solution to help more people who may have the same question to get the solution directly? Your contribution is highly appreciated!

Best Regards,

Icey

[AshDil · Accepted solution]

Hi @Icey ,

The actual,medium and high are coming from my dataset. 

So I write a calculation as follows

Calculation = If(Hasonevalue('Table[Size]'),'Table'[Size],Divide('Table'[Actual Value],'Table'[High Vale]))
I have renamed this Calculation (Divide('Table'[Actual Value],'Table'[High Vale])) as Accuracy.

Finally used that column in visual.

Thanks,

Ashdil