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] )
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
    • unnijoy's avatar
      unnijoy
      Icon for Post Prodigy rankPost 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.

      • Zubair_Muhammad's avatar
        Zubair_Muhammad
        Icon for Community Champion rankCommunity Champion
        8 years ago

        Hi unnijoy

         

        Could you share your file?