Fieldparameters for different multiple Measures

[showy]

Hi,

i have the following problem with fieldparameters. Unfortunately i cant attach the PBI.

I have a table with a Region, Counted Thefts and Counted Damages.
I want so show in a table region, the counted value and the percentage of each category as it is shown in the image:

The goal now is to combine these 4 Mesures (M1 - M4) in one table and controll it with fieldparameters.
I want two options in the fieldparameter with "Thefts" and "Damage"
When i choose "Thefts" the table should display Region, M1 and M2.
When i choose "Damage" the table should display Region, M3 and M4.

Data:

Thanks 😀

[AMeyersen · Accepted solution]

Hi @showy ,

you can use a field parameter but you need to manually adjust it
.

1. Create a field parameter and add all measures M1-M4
   
   
2. go to the modelling view and manually add a new column to the field parameter
   
   
   
3. rename the new column to a name of your choice e.g. "Selection"
   
   
   
4. create a visual and add the field parameter to the value section
   
   
   
5. create a slicer and add the custom selection column of the field parameter to the slicer
   

[VijayP]

@showy 

Here datamodelling matters! how these tables are connected, if they are different table not connected , field parameter will not help as the category column is not common for both measures. 

[showy]

thanks for your reply

the data are in one table. The model would be the Fact Table with Reagion/ Count Theft /Count Damage and a Dimension table with RegionCode/Country