Forum Discussion

Malsha's avatar
Malsha
Icon for Helper I rankHelper I
3 years ago

Measures Issue

Hi everyone, I have created these 3 measures for my power bi report and those 3 measures display as columns in the report.. 1.   column Total Worked: Total Worked = CALCULATE(     SUM('...
Need Help
BITomS's avatar
BITomS
Icon for Solution Supplier rankSolution Supplier
3 years ago

Hi Malsha 

 

For your 3rd measure, I think you can use an IF expression with ISBLANK:

 

Measure = IF(ISBLANK([Total Worked]),"N/A",[Total Worked] - [worked hours for selected period])

 

Hope this helps.

  • Malsha's avatar
    Malsha
    Icon for Helper I rankHelper I
    3 years ago

    Hi, This works but it gives duplicated records.