topic Creating Dax Success or Failure in DAX Commands and Tips

Creating Dax Success or Failure

Samiks95 — Mon, 31 Oct 2022 19:44:25 GMT

I have a column of Collected at club Percentage. I have different % here. If club has atleast collected 4 or more than 4% it's success. And if its less than 4% , its failed. How do I create a dax for this. Please help

Re: Creating Dax Success or Failure

besomebody20 — Mon, 31 Oct 2022 20:54:56 GMT

Hi Samiks95 ,

Please try this measure. It will return your expected results depending how it is used.

Club Grade = 
VAR countGreaterThan4Per =
    COUNTROWS(
        FILTER(
            'Sample Data',
            'Sample Data'[Decimal Percentage] > 0.04
        )
    )

RETURN
    IF(
        HASONEVALUE('Sample Data'[Club]),
        IF(
            countGreaterThan4Per >= 4,
            "Success",
            "Fail"
        )
    )

Results in a table visual

Re: Creating Dax Success or Failure

Anonymous — Mon, 31 Oct 2022 20:57:41 GMT

Hello Samiks95 ,

for new column:

Text = If( [Collected at Club Percentage]< 0.04,"Failed","Success"

and for measure :

Text = If( selectedvalue(table[Collected at Club Percentage])< 0.04,"Failed","Success"

if you find this helpful please accept as solution and a kudos is appreciated