Forum Discussion

Aspi's avatar
Aspi
Helper I
5 years ago
Solved

Visualization in Dashboard

Hello all you BI Gurus, wanted to ask if anyone knows how to create a visualization (or if one already exists) that will use values from two existing visualization and provide a result. See attached screenshot for reference to my question below:
I have a simple BI with three Card visualizations. How do I create another visualization that will use the data from the Card named 'AWB Count with Errors' and Divide it with the value data from the Card named 'Total AWBs Processed' to give me the Error Rate in percentage. I.e. 325/6109 = 5.32%
Thanks for your time.
Aspi.
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Aspi ,

     

    According to your description, the values displayed in the Card visuals are obtained by applying some filters not measures ,so you could not get the divide value directly,right?

     

    And based on the screenshots you provided ,let us ignore the date and region filter,just focus on Issue Category:

    AWB Count with Errors  is composed of data with the value<>(Blank) in Issue Category column,
    Total AWBs Processed is the total rows.
     
    I suggest you create some measures to do it.
    AWB Count with Errors = COUNTX(FILTER('Table','Table'[Issue Category]<>"(Blank)"),[Issue Category])

    Total AWBs Processed = COUNTROWS('Table')

    Error Rate = DIVIDE([AWB Count with Errors],[Total AWBs Processed])
     

    The final output is shown below:

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey Aspi ,

     

    you can easily create a new measure that is doing that:

    myMeasure =
DIVIDE(
    [AWB Count with Errors],
    [Total AWBs Processed]
)

     

    Then you format the Measure as percent and you should have your result.

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
  • Aspi's avatar
    Aspi
    Helper I
    5 years ago

    Hi Selimovd,

    Thanks for your quick response, however the issue is that data for AWB Count with Errors and Total AWBs Processed aren't two separate data sets i.e. columns. The data comes from the same column and gets displyed in the cards based on simple filters i.e if a row has an error populated against it then it will be counted in the card AWB Count with Errors'. So in short all the 3 cards are populating from the same column data.

    Hope I havent confused you. Do advise any other method you feel will work.

    Regards.

    Aspi. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Aspi ,

     

    According to your description, the values displayed in the Card visuals are obtained by applying some filters not measures ,so you could not get the divide value directly,right?

     

    And based on the screenshots you provided ,let us ignore the date and region filter,just focus on Issue Category:

    AWB Count with Errors  is composed of data with the value<>(Blank) in Issue Category column,
    Total AWBs Processed is the total rows.
     
    I suggest you create some measures to do it.
    AWB Count with Errors = COUNTX(FILTER('Table','Table'[Issue Category]<>"(Blank)"),[Issue Category])

    Total AWBs Processed = COUNTROWS('Table')

    Error Rate = DIVIDE([AWB Count with Errors],[Total AWBs Processed])
     

    The final output is shown below:

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Aspi's avatar
      Aspi
      Helper I
      5 years ago

      Hi Eyelyn,

      Thank you for your help and providing the solution. It has worked well.

      Can I ask you another question in relation to the same dashboard please. Can you advise how do I make the dashboard display 'Blanks' as 'No errors' i.e. I need the above Pie Graph showing 'No Errors' in place of '(Blank)' (the Purple 60% of the Pie).

      Do advise your thoughts.

      Best Regards.