Forum Discussion
calculated column not showing correct value when filter applied in Matrix table,
Hi, I have created a Matrix table. In Rows i have the level and in columns having activity and sub activity. In value i have shown the percentage of grade wise subactivity. I have used a filter to show as per the Item type. It is working fine. But after adding a calculated column in Rows, this calculted column is not showing the correct number in Matrix table. But in Table, it is working fine. Could you please help me out?
4 Replies
- lbendlin
Super User
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-Forum/ba-p/963216
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/1447523 I have added the data input.
BL BU DN SID JobName1 JobName2 Measure 5 ARK Market 5805 5805.03 PS 6 BD 7 0% ARK Market 5806 5806.06 n.a. n.a. 0% ARK Market 5806 5806.06 PS 5 n.a. 0% ARK OM 5802 5802.07 n.a. n.a. 0% ARK OM 5802 5802.09 n.a. n.a. 0% ARK OM 5802 5802.12 n.a. n.a. 0% ARK OM 5802 5802.12 PS 6 n.a. 0% ARK OM 5802 5802.14 n.a. n.a. 0% ARK OM 5803 5803.06 n.a. n.a. 0% ARK OM 5803 5803.07 n.a. BD 6 0% ARK OM 5803 5803.09 n.a. n.a. 0% ARK OM 5803 5803.1 n.a. n.a. 0% ARK OM 5803 5803.11 n.a. n.a. 0% ARK OM 5803 5803.11 PS 4 n.a. 0% ARK OM 5803 5803.13 PM 6 n.a. 0% ARK OM 5852 5852.11 PS 6 n.a. 0% ARK Staff 5810 5810 n.a. n.a. 350% ARK Staff 5810 5810 PS 6 n.a. 0% ARK Staff 5812 5812.02 PS 6 n.a. 0% DEN B&I 1800 1800 BD 10 n.a. 300% DEN B&I 1800 1800 LM 10 n.a. 200% DEN B&I 1800 1800 PM 10 n.a. 500% DEN B&I 1800 1800 PM 7 n.a. 700% DEN B&I 1800 1800 PS 10 n.a. 400% DEN B&I 1800 1800 PS 6 n.a. 0% The PBI report desired is in this format: here the requirement is the count should come in the ROW and measure value as Vlaues in the Matrix column. When filter applied the count should also show the number accordinlgy
BusinessLine ARK DEN JobName1 Jobname2 Head_Count Market OM Staff B & I GA Transport Utilities B10 LM 9 15 n.a. 3 3 7 6 PM 10 2 PS 10 1 6 PS 9 5 4 BD 7 BD 7 1 PM 5 2 5 PM 7 5 BD 8 LM 8 3 5 n.a. 1 PM 5 5 4 PM 6 6 2 PM 7 4 PM 8 1 PS 7 5 PS 8 2 PS 9 1 - lbendlin
Your sample data seems to be unrelated to your expected outcome. Which column is which?
