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 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.