Chart Discrepancies after Data Source Change

[Chitemerere]

I have a Power BI live dataset captured from Microsoft Forms which gives the following visual:

I use the following measures as values for the chart:

ISO-17025 Certified = CALCULATE(COUNTROWS(), FILTER(ALL(PMQSDataAfrica), SEARCH("ISO 17025 Certified",

PMQSDataAfrica[NQCLSatus],, BLANK()) > 0 ))

None = CALCULATE(COUNTROWS(), FILTER(ALL(PMQSDataAfrica), SEARCH("None",

PMQSDataAfrica[NQCLSatus],, BLANK()) > 0 ))

WHO-Prequalified = CALCULATE(COUNTROWS(), FILTER(ALL(PMQSDataAfrica), SEARCH("WHO prequalified",

PMQSDataAfrica[NQCLSatus],, BLANK()) > 0 ))

 I then downloaded the data from Microsoft Forms in an Excel format and the data is as follows:

NQCLSatus

None;

None;

None;

Some monitoring tests ;None;

Laboratories approved by the Ministry of Health; None;

None;

In the process of prequalification with the World Health Organization and ISO-17025 accreditation

ISO 17025 Certified;WHO prequalified;

ISO 17025 Certified;

ISO 17025 Certified;WHO prequalified;

None;

ISO 17025 Certified;

Using the same measures as above, I am getting a chart different from the above with the same data except that the source is now from Excel as give above:

 The chart above does not have values for ISO 17025 for some strange reason although these are available in the Excel data given above.  Please assist in troubleshooting.

Regards,

Chris

[Chitemerere · Accepted solution]

Managed to sort it out, there were some issues to some column references.

Regards,

Chris