Forum Discussion

kozmar's avatar
kozmar
Frequent Visitor
9 years ago
Solved

Power BI DAX Patterns Products/Locations

I have a need to identify products (and counts for % of total) based on the following scenerios. The locations are a slicer filter applicable to all.    1. If the product exists in one location, fl...
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi kozmar,

    I am thinking I should be able to have flags on the product dimension, and set them dynamically based on facts grouping the count of products based on filters.

    According to your description, are you trying to add dynamic column calculation based on Slicer Selection in your product dimension table?

     

    If that is the case, it is not possible to do it because calculated columns are initialized regardless of Slicers. However, you can create a measure to show the flag with the Products in the report. Here is a similar thread for your reference.

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi kozmar,

I am thinking I should be able to have flags on the product dimension, and set them dynamically based on facts grouping the count of products based on filters.

According to your description, are you trying to add dynamic column calculation based on Slicer Selection in your product dimension table?

 

If that is the case, it is not possible to do it because calculated columns are initialized regardless of Slicers. However, you can create a measure to show the flag with the Products in the report. Here is a similar thread for your reference.

 

Regards

kozmar's avatar
kozmar
Frequent Visitor
9 years ago

Yes, that works. thanks! 

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi kozmar,

     

    Great to hear the problem got resolved.:smileyhappy: Could you accept the corresponding reply as solution to close this thread?

     

    Regards

    • kozmar's avatar
      kozmar
      Frequent Visitor
      9 years ago

      Yes!! reply accepted as solution. thanks.