Forum Discussion

sanju24566's avatar
sanju24566
Regular Visitor
3 years ago

thanks but isnt this possible with measure

NikhilChenna's avatar
NikhilChenna
Skilled Sharer
3 years ago

Hi sanju24566 ,

 

Try using Summarize with measure and let me know. Creating a summarized table is suitable in this situation.

 

Regards,

Nikhil Chenna

 

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

 

 

  • sanju24566's avatar
    sanju24566
    Regular Visitor
    3 years ago

    Hello Nikhil 

    Thanks for the solution. But the results are not what I expected

    I wanted to know the No. of Site Counts >=1.5 yearwise. It is showing me the Total Count of Site Code

    • sanju24566's avatar
      sanju24566
      Regular Visitor
      3 years ago

      This is what I want to achieve. Can I use a related function anywhere?

      • NikhilChenna's avatar
        NikhilChenna
        Skilled Sharer
        3 years ago

        Hi sanju24566 ,

         

        I think we already got the solution. you just have to visual level fiter to this visual.

         

        After this you can create calculated column to for your condition of value 1.5 average value.
        calculated column = IF('table1'[AvgValue]>=1.5,1,0)
         
        Add this calculated column as visual level filter. You should get the desired output.
         
        Regards,
        Nikhil Chenna
         
        Appreciate with a Kudos!! (Click the Thumbs Up Button)
        Did I answer your question? Mark my post as a solution!