See Records when value is set to Show as a Percentage

[PaulSev]

My goal is to 'See Records' when I set my value to Show as a Percentage. While it is a number, See Records is available. I am using a Matrix visual, Months as Rows, Count of Column as colum

[Ashish_Mathur · Accepted solution]

Hi,

Someone else will help you with this one please.

[Ashish_Mathur]

Hi,

Share the dataset and show the expected result.

[PaulSev]

Thank you for your responses so far. I'm new here and don't know how to share a dataset. If the following doesn't help explain my question I will learn how to share

Let me provide the written detail.

My Matrix visual displays the number of Incidents of  each type.

• My dataset consists of column A = Incident (each value in this column is an incident number), column B = Incident Type. The Incident can be 1 of 2 types,
• In my Matrix Visual, I have Rows = Incident Type, Values = Incident. For the values, I use the drop down menu on Incident and select Count. This gives me the number of Incidents for each Incident Type.

Within the Matrix visual, if I right click a number, I'm presented with 4 options, the first being 'See Records'. Selecting See Records opens  a new tab with a table showing the underlying records.

All good upto now.

In my Matrix visual, I want to see a percentage in my values, not a number.  To do this I  use the drop down menu on the value 'Incident' and select Show value as > Percentage of column total.

Within the Matrix visual, If I right click a %, I'm presented with only 3 options. The 'See Records' option is no longer available.

My question is: is this by design or do I have to do something different?

[Anonymous · Accepted solution]

@PaulSev,

The behavior you describe is by design. When you choose Show value as > Percentage of column total in Matrix, it has same effect as that you create a measure using the Dax below to calculate the pecentage.

Measure = COUNTA(Table1[Incident])/CALCULATE(COUNTA(Table1[Incident]),ALL(Table1))

 See Records can't be used when your visual uses a calculated measure.

Regards,
Lydia

[PaulSev]

Thank you for your time and consideration

[Ashish_Mathur · Accepted solution]

Hi,

Someone else will help you with this one please.

[Anonymous]

I'm having difficulty understanding your question.  Can you please rephrase?

It sounds like you have a field that has some numbers and some non-numbers and you only wish to show rows that have values that are a percentage? Is that correct?