Forum Discussion

Chanleakna123's avatar
Chanleakna123
Post Prodigy
6 years ago

Create Slicer for Measure ,

Hi ,  good day.  I have built a report which to track how many Outlets are Active or InActive , All are Tracking based on duration of 3 , 6 & 12 Months. I have created the formula for 3 months , 6...
Need Help
Chanleakna123's avatar
Chanleakna123
Post Prodigy
6 years ago
Hi , can u show me how ? I have used calculated column , but it turns not eights , since all the data of 3 months , 6 & 12 months are already combined with measure.
JQuon's avatar
JQuon
Helper I
6 years ago

Actually, after reviewing your question and the design behind the logic, I understand where the complication is.  Let me digest this a little more and see if I can come up with a solution.

  • Chanleakna123's avatar
    Chanleakna123
    Post Prodigy
    6 years ago

    JQuon , hi  do you have any update in this regards ? 
    looking forward your response 🙂 . 

     

    Thanks with Regards, 
    Chanleakna Hang 

    • JQuon's avatar
      JQuon
      Helper I
      6 years ago

      Chanleakna123 , are you able to share the PBIX file?  I think the only way to do this is through calculated columns.  It may not be ideal, but you may not to do calculated columns on an aggregate table to achieve your goal.

      • Chanleakna123's avatar
        Chanleakna123
        Post Prodigy
        6 years ago

        hi v-xicai  it doesn't shown the preference result . 

         

        HI JQuon  i have shared through the message of the BI File. Can you please review it ? 

        thx