Percentage Graph

[Anonymous]

I've Managed to get a absolute count column chart in my report using Visual Level Filtering ChartVisual Filters

How would i turn this into a Percentage Chart (i.e. Percentage values up to  to 100% the X-Axis.)

I'm thinking along the lines of a Measure which does a COUNTA of Incident ID divide by COUNTA of Breach where value is equal to OK. leaving the rest to visual level filters like i have done with the above graph.

Its worth mentioning the fields are text based not numerical hence the use of CountA. (is this correct???)

[v-yuta-msft · Accepted solution]

@Anonymous,

Yes, if the column contains text, logic values, you would better use COUNTA instead of COUNT, to be general, you may create a measure using DAX formula like pattern below:

Measure =
COUNTA ( Table[Incident ID] )
    / COUNTAX ( FILTER ( Table, Table[Breach] = "OK" ), Table[Breach] )

Then drag the measure into value field.

Regards,

Jimmy Tao