Forum Discussion
Filtered value minus 1
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" }
)
Hi Anonymous
This perhaps?
Alexej =
CALCULATE(
COUNTA('Tabelle1'[Wer hat geputzt?]),
'Tabelle1'[Wer hat geputzt?] IN { "Alexej" }
) - 1Please 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.
2 Replies
Hi Anonymous
This perhaps?
Alexej =
CALCULATE(
COUNTA('Tabelle1'[Wer hat geputzt?]),
'Tabelle1'[Wer hat geputzt?] IN { "Alexej" }
) - 1Please 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.