Forum Discussion

unnijoy's avatar
unnijoy
Post Prodigy
8 years ago
Solved

Formula Help

Month Country Site Program Name HC Jan-18 US Greenville Running 464 Jan-18 US Greenville Running 464 Jan-18 US Greenville Running 464 Jan-18 US Greenville Running 4...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    unnijoy

     

    Please try this MEASURE

     

    MeasureF =
VAR temp =
    CALCULATETABLE ( DISTINCT ( Table1[HC] ), ALL ( Table1[Mode] ) )
RETURN
    SUMX ( temp, [HC] )
unnijoy's avatar
unnijoy
Post Prodigy
8 years ago

Hi Thanks for the Prompt reply. A small change in the Table.

 

MonthCountrySiteProgram NameModeHC
Jan-18USGreenvilleRunningOnline464
Jan-18USGreenvilleRunningILT464
Jan-18USGreenvilleRunningOnline464
Jan-18USGreenvilleRunningILT464
Jan-18USGreenvilleRunningOnline464
Jan-18USGreenvilleRunningILT464
Jan-18USDalevilleRunningOnline696
Jan-18USDalevilleRunningILT696
Jan-18USDalevilleRunningOnline696
Feb-18USGreenvilleRunningILT424
Feb-18USGreenvilleRunningOnline424
Feb-18USGreenvilleRunningILT424
Feb-18USDalevilleRunningOnline400
Feb-18USDalevilleRunningILT400
Feb-18USDalevilleRunningOnline400
Feb-18USGreenvilleRunningILT424

 

In the Table we can see Mode. So the HC should be calculated irrespective of Mode.

By the formula that u gave the system will calculate the HC seperately for each mode. our Formula should not be based on mode.

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi unnijoy

 

I get correct results with the revised table even

 

Please see attached file