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