facing an issue adding measures in the table

[Emerald70]

Qualify	Type	Amount
Y	Actual	2000
Y	Forecast	3000
N	Actual	50000
N	Forecast	10000

have a data like this 
and needed a below 4 measures to be added in the table,  but when iam adding all facing an error like "could not load data for the visual"  please help??

QNA = calculate( sum(Sheet1[Amount]), Sheet1[Qualify] = "N" && Sheet1[Type] = "Actual")

QNF = calculate( sum(Sheet1[Amount]), Sheet1[Qualify] = "N" && Sheet1[Type] = "Forecast")

QYA = calculate( sum(Sheet1[Amount]), Sheet1[Qualify] = "Y" && Sheet1[Type] = "Actual")

QYF = calculate( sum(Sheet1[Amount]), Sheet1[Qualify] = "Y" && Sheet1[Type] = "Forecast")

[Anonymous]

Hi @Emerald70 , hello Ashish_Mathur and Ritaf1983, thank you for your prompt reply!

I'm checking how the things are going on about this issue. Whether the answer helps you?

If you find any answer is helpful to you, please remember to accept it.

It will help others who meet the similar question in this forum.

Thank you for your understanding.

[Ashish_Mathur]

Hi,

In the Query Editor, ensure that the data type of the Amount column is Number.

[Emerald70]

Try to keep 4 measures in a table and check with the same data

[Ritaf1983]

@Emerald70 

still seems ok.
I also attached a pbix
If my answer was helpful please give me a Kudos and accept as a Solution.

[Ritaf1983]

Hi @Emerald70 
The formulas seem correct + work with the small table that you attached

May be the problem is with the data model or something.
What is a data source?
Do you use an import mode or direct query?