Forum Discussion
Using one Field Parameter for two tables
- Anonymous2 years ago
Hi SpicyRamen22 ,
Based on your description, there is a need to adjust our test data. The data is as follows:
Slicer = DATATABLE ( "Slicer", STRING, "index",INTEGER, { { "Item",1 }, { "Dimension",2 }, { "Seqment",3 } } )Then we can create measures.
Measure 3 = var _min=MINX(ALLSELECTED('Slicer'),[Slicer]) var _a=CALCULATE(MAX('Table (2)'[Value]),FILTER(ALLSELECTED('Table (2)'),[id] in VALUES('Table (2)'[id]) && [Attribute]=_min)) RETURN IF(ISFILTERED('Slicer'[Slicer]) = FALSE(),BLANK(),_a)Measure 4 = var _max=MAXX(ALLSELECTED('Slicer'),[Slicer]) var _a= CALCULATE(MAX('Table (2)'[Value]),FILTER(ALLSELECTED('Table (2)'),[id] in VALUES('Table (2)'[id]) && [Attribute]=_max)) RETURN IF(COUNTROWS(VALUES('Slicer'[Slicer]))=1 || ISFILTERED('Slicer'[Slicer]) = FALSE(),BLANK(),_a)Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SpicyRamen22 , Ideally, You should create a common Item, and segment dimensions. Join back with your tables and then create field parameters on dimension tables
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda
Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw
A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f