Filtered value minus 1

[alexej53480]

Hi everyone

I recently got into Power BI and build a simple report. My coding experience is not so good, so please understand if this question is kinda stupid for some peoples here ^^

I did a quick measure where it gives me a filtered value back and I want to calculate minus 1 from this value. What do I have to add to this code? I thought it would be easy but as I mentioned, my coding experience is meh. Thanks for your help 🤗

Alexej = 
CALCULATE(
    COUNTA('Tabelle1'[Wer hat geputzt?]),
    'Tabelle1'[Wer hat geputzt?] IN { "Alexej" }
)

[AlB · Accepted solution]

Hi @alexej53480 

This perhaps?

Alexej = 
CALCULATE(
    COUNTA('Tabelle1'[Wer hat geputzt?]),
    'Tabelle1'[Wer hat geputzt?] IN { "Alexej" }
) -  1

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[alexej53480]

Jup this worked perfectly... Thank you so much ❤️