Forum Discussion

unnijoy's avatar
unnijoy
Icon for Post Prodigy rankPost 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] )
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

HI unnijoy

 

Try this MEASURE

 

Measure =
SUMX ( VALUES ( Table1[HC] ), CALCULATE ( VALUES ( Table1[HC] ) ) )
unnijoy's avatar
unnijoy
Icon for Post Prodigy rankPost 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.

    • unnijoy's avatar
      unnijoy
      Icon for Post Prodigy rankPost Prodigy
      8 years ago

      Hi Zubair_Muhammad

       

      In that output table we have to include Mode also. We have once for field come in this table. For that we got the formula. Can you please help me to get the data in the below format.

       

      MonthcountryModeHC
      Jan-18USILT1160
      Jan-18USOnline1160
      Feb-18USILT824
      Feb-18USOnline824