Forum Discussion

DidacBF's avatar
DidacBF
Frequent Visitor
4 years ago
Solved

Filtering data based on dynamic segmentations (measure)

Hello guys, first of all sorry for my English, I will try to explain what I want to achieve the best I can. Not sure the Subject is very clear... I reduced my model so I can show you easily what ...
Need Help DAX
Need Help DAX measure
  • lbendlin's avatar
    lbendlin
    4 years ago

    i think you are on the right track. You cannot count measure results. You need to convert measure groups to (temporary) tables before you can do the segment assignment. This means you need to use completely different measures to compute these segmentations.  Don't expect the results to be flexible - they will be highly specialized to work in a very narrow UI band. The moment your customer wants you to add "just one more small filter"  you may have to redo everything.

     

    Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Please show the expected UX outcome.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

i think you are on the right track. You cannot count measure results. You need to convert measure groups to (temporary) tables before you can do the segment assignment. This means you need to use completely different measures to compute these segmentations.  Don't expect the results to be flexible - they will be highly specialized to work in a very narrow UI band. The moment your customer wants you to add "just one more small filter"  you may have to redo everything.

 

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Please show the expected UX outcome.