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

 

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.

  • unnijoy's avatar
    unnijoy
    Post Prodigy
    8 years ago

    Hi Zubair_Muhammad

     

    Am not getting a opetion to upload the file.

  • unnijoy's avatar
    unnijoy
    Post Prodigy
    8 years ago
    MonthRegionCountrySiteProgram NameDelivery TypeHC
    Jan-18North AmericaUSRochester-ILT16
    Jan-18North AmericaCanadaWHT-ILT205
    Jan-18North AmericaUSWHT-ILT2426
    Jan-18North AmericaUSRochester-ILT16
    Jan-18North AmericaUSWHT-ILT2426
    Jan-18North AmericaUSRochester-ILT16
    Jan-18North AmericaUSMorrisville-ILT4
    Jan-18North AmericaUSWHT-ILT2426
    Jan-18North AmericaUSGreenville-ILT464
    Jan-18North AmericaUSST. LOUISG2ILT20
    Jan-18North AmericaUSGreenvilleC45ILT464
    Jan-18North AmericaUSWHT-ILT2426
    Feb-18North AmericaUSWHTG2ILT2053
    Feb-18North AmericaUSWHTG2ILT2053
    Feb-18North AmericaUSWHT-ILT2053
    Jan-18North AmericaUSGreenville-ILT464
    Jan-18North AmericaUSWHT-ILT2426
    Jan-18North AmericaUSWHT-ILT2426
    Jan-18North AmericaUSWHT-ILT2426
    Jan-18North AmericaUSST. LOUISG2ILT20
    Jan-18North AmericaUSWHT-ILT2426
    Jan-18North AmericaUSWHT-ILT2426
    Jan-18North AmericaUSWHT-ILT2426
    Jan-18North AmericaUSWHT-ILT2426
    Jan-18North AmericaUSGreenville-ILT464
  • unnijoy's avatar
    unnijoy
    Post Prodigy
    8 years ago
    MonthRegionCountrySiteProgram NameDelivery TypeHC
    Jan-18North AmericaUSRochester-ILT16
    Jan-18North AmericaCanadaWHT-ILT205
    Jan-18North AmericaUSWHT-ILT2426
    Jan-18North AmericaUSRochester-ILT16
    Jan-18North AmericaUSWHT-ILT2426
    Jan-18North AmericaUSRochester-ILT16
    Jan-18North AmericaUSMorrisville-ILT4
    Jan-18North AmericaUSWHT-ILT2426
    Jan-18North AmericaUSGreenville-ILT464
    Jan-18North AmericaUSST. LOUISG2ILT20
    Jan-18North AmericaUSGreenvilleC45ILT464
    Jan-18North AmericaUSWHT-ILT2426
    Feb-18North AmericaUSWHTG2ILT2053
    Feb-18North AmericaUSWHTG2ILT2053
    Feb-18North AmericaUSWHT-ILT2053
    Jan-18North AmericaUSGreenville-ILT464
    Jan-18North AmericaUSWHT-ILT2426
    Jan-18North AmericaUSWHT-ILT2426
    Jan-18North AmericaUSWHT-ILT2426
    Jan-18North AmericaUSST. LOUISG2ILT20
    Jan-18North AmericaUSWHT-ILT2426
    Jan-18North AmericaUSWHT-ILT2426
    Jan-18North AmericaUSWHT-ILT2426
    Jan-18North AmericaUSWHT-ILT2426
    Jan-18North AmericaUSGreenville-ILT464
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    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,

     

    Amazing. It is working. Thanks al lot for your help and time.