Need to convert this DAX query to SQL

[Anonymous]

Can anyone let me know how to convert

Need to convert this DAX query to SQL

> 2% Net Outflows =

IF(COUNTROWS(FILTER('Fund Flow','Fund Flow'[NET_PERCENT_1D] < -0.02)) = 0,BLANK(),COUNTROWS(FILTER('Fund Flow','Fund Flow'[NET_PERCENT_1D] < -0.02)))

can any one help me plz

[Anonymous]

Hi @Anonymous ,

Please have a try.

SELECT 
    CASE 
        WHEN 
            COUNT(CASE WHEN [NET_PERCENT_1D] < -0.02 THEN 1 END) = 0 
        THEN 
            NULL 
        ELSE 
            COUNT(CASE WHEN [NET_PERCENT_1D] < -0.02 THEN 1 END) 
    END AS [2% Net Outflows] 
FROM 
    [Fund Flow]

Solved: Convert DAX Measure to SQL - Microsoft Fabric Community

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Legend_11]

select colum1,col2,
CASE
WHEN (
SELECT COUNT(*)
FROM FundFlow
WHERE NET_PERCENT_1D < -0.02
) = 0 THEN NULL
ELSE (
SELECT COUNT(*)
FROM FundFlow
WHERE NET_PERCENT_1D < -0.02
)
END AS Result from table