DAX if statement using a measure to display a status

[dtartaglia]

Hi,

I cannot seem to get this to work. I'm trying to create a column in my table that displays a status depending on a values from a column and measure. vwRevitDocumentSession[DocumentSessionDurationMin] is coming from a database and vwRevitEvent[Number of Synchs] is a measue:

Number of Synchs = CALCULATE(COUNTROWS(vwRevitEvent), vwRevitEvent[RevitEventName] = "DocumentSynchronization")

The below statement seems to blank all values for: vwRevitEvent[Number of Synchs]

Num Sync Status = IF(VALUES(vwRevitDocumentSession[DocumentSessionDurationMin]) / VALUES(vwRevitEvent[Number of Synchs]) > 60, "Bad", "Good")

...I'm just looking to display a status value to show if my IF meets recommended.

Thanks,

Dan

[parry2k]

Why you are using value function?

[dtartaglia]

Hi,

What should I use? I'm drawing a blank getting this to work. I have to evaluate each row value and I'm in DirectQuery mode. Tried a number of things.

Thanks,

Dan

[v-huizhn-msft]

Hi @dtartaglia,

Your measure "Num Sync Status " return all blank, rather than Good or Bad, right? Could you please share your sample data for further analysis? Based on my understanding, the "Number of Synchs" measure will count all the row where  vwRevitEvent[RevitEventName] = "DocumentSynchronization", the result shoud be one rather than mutiple.

Best Regards,
Angelia

[dtartaglia]

Hi,

Your right, 'Number of Synchs' is reducing the number of rows in the table and my 'status' is trying to process by row (sorry, I didn't think about that before posting). I'm not sure I can do the 'status' then.

Dan

[v-huizhn-msft]

Hi @dtartaglia，

There are relationship between 'vwRevitDocumentSession' and 'vwRevitEvent' tables, right? If it is, you can create a calculated column in 'vwRevitDocumentSession' table to get your result.

Num Sync Status = IF((vwRevitDocumentSession[DocumentSessionDurationMin] / vwRevitEvent[Number of Synchs]) > 60, "Bad", "Good")

If this is what you want, could you please share the sample data or .pbix file for further analysis.

Best Regards,
Aneglia

[dtartaglia]

Hi Aneglia,

'Number of Syncs' is a calculated mesuase, If I use your example, vwRevitEvent[Number of Synchs] cannot be found in the DAX statement. I will attempt to post some of the data but it is all coming from a large private SQL db.

Thanks,

Dan

[v-huizhn-msft]

Hi @dtartaglia，

Please verify there is relationship between 'vwRevitEvent' and 'vwRevitDocumentSession'. I understand you all data come from a large private SQL db. You'd better create sample similar table by yourself.

Best Regards,
Angelia