Forum Discussion

AshDil's avatar
AshDil
Icon for Helper V rankHelper V
4 years ago
Solved

Want to show custom matrix table

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   % Accu...
Need Help
  • AshDil's avatar
    AshDil
    4 years ago

    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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

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's avatar
AshDil
Icon for Helper V rankHelper V
4 years ago

Hi Greg_Deckler ,

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

Thanks,

AshDil.

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    4 years ago

    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's avatar
      AshDil
      Icon for Helper V rankHelper V
      4 years ago

      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