Forum Discussion

Junaid11's avatar
Junaid11
Helper V
4 years ago

Dax function recreate

Hello, I had this data below: Date SalesOrder Revenue Department 11/02/2020 A1 25210 P 11/02/2020 A2 56732 L 11/02/2020 A3 45627 L 12/02/2020 A1 25210 P 12/02/2020 ...
Need Help
Pragati11's avatar
Pragati11
Super User
4 years ago

Hi Junaid11 ,

 

Try modifying the DAX as follows:

Measure =
IF (
    CALCULATE (
        DISTINCTCOUNT ( 'Table 1'[Date] ),
        ALLEXCEPT ( 'Table 1', 'Table 1'[SalesOrder], 'Table 1'[Department] )
    ) = 1,
    SUM ( 'Table 1'[Revenue] )
)

 

Thanks,

Pragati

  • Junaid11's avatar
    Junaid11
    Helper V
    4 years ago

    Hello Pragati11 ,

    I have already done that but it is still not working.

    • v-chenwuz-msft's avatar
      v-chenwuz-msft
      Community Support
      4 years ago

      Hi Junaid11 ,

       

      From your description, you should want to use a gong'neng similar to this function:

      HASONEVALUE(<columnName>)

      Try this code:

      Measure = 
IF(
    HASONEVALUE( 'Table'[Department] ),
    SUM( 'Table'[Revenue] ),
    BLANK()
)

      result:

       

      Best Regards

      Community Support Team _ chenwu zhu

       

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