SQL Server & Tibco Spotfire Ideas & Samples
SQL, TSQL, Tibco Spotfire...
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment