Forum Discussion

PBI_Rookie's avatar
PBI_Rookie
Icon for Helper I rankHelper I
5 years ago
Solved

Control Charting-ALLSELECTED

Hello All,   I've previosuly created control charts using a dataset with only the data needed. I am now trying to use the same measures to create the control charts where the data needed is only a ...
Need Help
  • PBI_Rookie's avatar
    PBI_Rookie
    5 years ago

    I was finally able to get this to work. 

     

    I used AllSELECTED as I described initially. What I had to do to make it work however was to duplicate my source table and filter it to be only the needed information. In this case the sample IDs. 

littlemojopuppy's avatar
littlemojopuppy
Icon for Community Champion rankCommunity Champion
5 years ago

Hi!  Try changing ALLSELECTED() to KEEPFILTERS(Identifier I want to sort by]).

  • PBI_Rookie's avatar
    PBI_Rookie
    Icon for Helper I rankHelper I
    5 years ago

    Hi, 

     

    Ok I tried replacing the ALLSLECTED in both measures with KEEPFILTERS. I get an error that "Cannot convert value (identifier) of type TEXT to type True/False"

     

     

    • littlemojopuppy's avatar
      littlemojopuppy
      Icon for Community Champion rankCommunity Champion
      5 years ago

      😮  Well that is certainly an unusual error message...

       

      Can you provide some sample data to play with?

      • PBI_Rookie's avatar
        PBI_Rookie
        Icon for Helper I rankHelper I
        5 years ago

        Playing with KeepFilters a bit I can see why it is giving me that error. If I alter it a bit i.e. KeepFilters(Column="") i will not get the error. Unfortunately it also does not solve the initial issue.