Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Need Help Writing A Formula

Hello All,   I  would appreciate any ideas from the community to help me figue out how to write an appropriate formula for the scenario below. I have data that has the following columns: incident ...
Need Help
  • v-joesh-msft's avatar
    v-joesh-msft
    6 years ago

    Hi Anonymous ,

    You can try  the measure below:

    remove not called =
VAR _TABLE =
    CALCULATETABLE (
        SUMMARIZE (
            'Data SUV',
            'Data SUV'[Name],
            'Data SUV'[Date].[Date],
            "_VALUE", [last three month]
        ),
        ALLEXCEPT ( 'Data SUV', 'Data SUV'[Name] )
    )
RETURN
    IF (
        COUNTAX ( FILTER ( _TABLE, [_VALUE] <> BLANK () ), [_VALUE] ) <> 0,
        COUNTROWS ( 'Data SUV' )
    )

    Results are as follows：

     

    Best Regards,

    Community Support Team _ Joey
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.