Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 ...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    Hi Anonymous 

    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.

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous 

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.

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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