topic Re: if statement with percentage in DAX Commands and Tips

if statement with percentage

Krijgersss — Tue, 18 Jun 2024 12:52:34 GMT

i need some help with my if statement how can i make it that it wil get my percentage range

Kolom = IF([% Uren begroot] > "80%" && [% Uren begroot] <= "100%", filter ( operation implementatie))

the filter comes out of a colum and the urenbegroot is a messeaure

the value i need must be a number so i can place it in a Circkel diagram

Re: if statement with percentage

BiAnalyst — Tue, 18 Jun 2024 14:02:06 GMT

you pretty much have it correct.

try following,

Kolom =
IF(
[% Uren begroot] > 0.8 && [% Uren begroot] <= 1,
"Operation Implementatie",
BLANK()
)

If suggestion works, please accept it as solution.