Forum Discussion

gomezc73's avatar
gomezc73
Helper V
2 years ago
Solved

Multi PCI Card help

Hi Experts,      I need help to show more information in a chart.      Let me explain.      I have this chart with calculated data           Additional, i need show for the same period...
Need Help
  • mostho's avatar
    mostho
    2 years ago

    Well, then there must be something in your data model or connections in your visuals that you didnt specify yet.

    As you can see on my screenshot (last post), it works for me. you can have a look at my pbix.

mostho's avatar
mostho
Helper II
2 years ago

 

I still dont get your issue. If you should take the values as they are (without calculation), then the records must be unique - one per period, right?

If so, where is the problem with sum in the matrix visual? the sum of a single value is the single value - you could also take min or max or whatever ...

If the records are not unique (per period) what should then be shown - without calculation?

gomezc73's avatar
gomezc73
Helper V
2 years ago

Hi,

 

When i tried to show the data in a matrix, the 'commision rate' is required with SUM/AVG, etc.

 

If i select SUM, by example the the rate in the period is the same 2851.54 in the four periods

 

 

 

  • mostho's avatar
    mostho
    Helper II
    2 years ago

    Well, then there must be something in your data model or connections in your visuals that you didnt specify yet.

    As you can see on my screenshot (last post), it works for me. you can have a look at my pbix.

    • gomezc73's avatar
      gomezc73
      Helper V
      2 years ago

      Ok Thank you.

       

      I going to validate my data..