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

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