Forum Discussion

Aikeno's avatar
Aikeno
Icon for Helper I rankHelper I
2 years ago

Measure based on several conditions

Hello everyone,   I would like to have a measure that would give me the result in the column "Test done" in blue table in my report. Yellow and orange are data table and they are linked by the Pro...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

Aikeno , Try a measure

 

Test Done =
VAR _TotalVDV = CALCULATE(
COUNTROWS(vw_vision_activity),
vw_vision_activity[activity category] = "VDV"
)
VAR _ClosedVDV = CALCULATE(
COUNTROWS(vw_vision_activity),
vw_vision_activity[activity category] = "VDV",
vw_vision_activity[activity state] = "Closed"
)
VAR _opendVDV = CALCULATE(
COUNTROWS(vw_vision_activity),
vw_vision_activity[activity category] = "VDV",
vw_vision_activity[activity state] = "Active"
)
RETURN
Switch( true() ,
not(isblank([_opendVDV])), "No",
[_TotalVDV] > [_ClosedVDV], "Yes"
)

 

 

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.