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
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.