Jan 31, 2024

Power BI Measure - DAX query to count string values

 Total =

VAR Count1= [field1]
VAR Count2=[field2]
VAR T1= SWITCH(TRUE(), SELECTEDVALUE(dataset1[IsRequired])="Yes",Count1, SELECTEDVALUE(dataset1[IsRequired])="NA",Count2)
Return T1

No comments: