this is relatively simple if you use set analysis...
load all the data without where condition and try to put set analysis in expression of your chart/table.
if you want to implement "If there are no priority Urgent and state = MA, the user wants to have the chart display "No records found".
Then in General tab of your chart in calculation condition box put somthing like if(Priority='Urgent' and State='MA')
after that in error message tab put "No Recorts found" for calculation condition unfullfilment.