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
JQuon's avatar
JQuon
Helper I
6 years ago

Would you benefit using a calculated column instead of a measure and using that data field as the slicer?

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.