Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys,
is it possible to create a dynamic measure? I want to subtract two dynamic parts. For example i have 10 numbers and want to subtract them in all possible combinations only in one measure. Is that possibe with filters/slicers?
Thank You
Best regards
Solved! Go to Solution.
@Anonymous , Not very clear, but with an independent slicer, you can create two set products to filter
Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE
better example with date table
Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
If not
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@Anonymous , Not very clear, but with an independent slicer, you can create two set products to filter
Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE
better example with date table
Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
If not
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Thanks. Looks promising. WIll try it
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |