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.

  • unnijoy's avatar
    unnijoy
    Post 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
      • unnijoy's avatar
        unnijoy
        Post Prodigy
        8 years ago

        Hi Zubair_Muhammad

         

        I am getting it seperately. Like for December HC filters based on Online and ILT. In the top I have 4 slicers. Month, country, Program name,Mode. Is the mismatch because of this.