Need help to write a measure

[Anonymous]

Hi,

Please refer the below link to download the sample report pbix

https://www.dropbox.com/s/2io37811qat95b8/sample%20report.pbix?dl=0

Current Behavior:

If i select any row in product_data table... table 2 table is displaying with the respective data of that selected quote and version.

followed below steps to achieve the requirement:

Created a copy from product table to achieve the requirement.

Steps:

1. Create new table based on product table and use new table to build visual.

Table formula:

Table = product_data

2.  measure to get selected value from new table, then compare table 2 row contents with above value to return tag.

Measure:

Tag =
IF (
MAX ( addon_data[version] ) IN ALLSELECTED ( 'Table'[version] )
&& MAX ( addon_data[quoteNo] ) IN ALLSELECTED ( 'Table'[quoteNo] ),
1,
0
)

3. Drag tag measure to table 2 visual level filter.

i want to add below condition to the measure:

If i select any row in product_data table... table 2 table is displaying with the respective data of that selected quote and version. Along with that, I also need condition so that the proposalId column value in table 2 to be replaced with proposalNewId column value (i.e. 12 ). fyi... proposalNewId column is in addon_data table.

[Seward12533]

Can you please clarify what your after? If your trying to actually modify the contents of a table based on a slicer condition this is not possible as any calculated  columns are calculated when the worksheet is opened or data is refreshed but BEFORE any slicer selections are made. 

IF you just want to to display the value of your proposal new ID (I.e. 12) to be displayed in your visual then just drag it in and set the the calculation to any aggregate measure like MAX, MIN etc and rename.  If you want to conditionally display this alternate  value you would need to write a measure.

Can you mock up what you want the desired output to be?  

[Anonymous]

Thank you for reply. Appreciate it. 

 If  User selects the selected record in the product_data table then the expected behavior should be like below

Attached  mockup is the desired output.   

please let me know if  further information is needed. 

 If  User unselects the selected record in the product_data table then the expected behavior should be like below,  i.e.  proposalId column value in table 2   should be replaced with  1 . 

[v-frfei-msft]

Hi @Anonymous,

We can create a measure like this to meet your requirement.

Measure 2 = IF(ISFILTERED(product_data[category]),MAX(addon_data[proposalId]),MAX(addon_data[proposalNewId]))

For more details, please check the pbix as attached.

https://www.dropbox.com/s/t2t42p4sb7zz1ep/sample%20report%20%281%29.pbix?dl=0

Regards,

Frank

[Anonymous]

Hi,  Need some help. Please correct my mistake in the measures .  

I have tried to incorporate the same measure logic in  the power bi report  i am working  on but seems to be the measures are not working.  The issue is   the Filter value always displays "SinglePartWarrantyRate" column value and  switch condition  is not working.  I have used 2 measures  but nothing is working.  Please correct my mistake .  

Measures I used:

Filter = IF(
ISFILTERED('VehicleTrend'[LoDate]),SWITCH(CALCULATE(SUM(VehicleTopIssue[C/100])),MAX('VehicleTopIssue'[C/100]),MAX(VehicleTopIssue[SinglePartWarrantyRate])),CALCULATE(SUM('VehicleTopIssue'[C/100]))
)

 or

Filter =
IF(
ISFILTERED(VehicleTrend[LoDate]),MAX(VehicleTopIssue[C/100]),MAX(VehicleTopIssue[SinglePartWarrantyRate])
)

I have 2 columns  "C/100"   and    "SinglePartWarrantyRate" in table. these columns are decimal(11,10) datatypes. refer the screenshot.

Requirement:

1) if user selects the LoDate column (i.e. August 2017)  in a Line and stacked column chart ( refer  the screenshot  ) the filter measure should display the "SinglePartWarrantyRate" column value.

2) If  User unselects theLoDate column (i.e. August 2017)  in a Line and stacked column chart then the expected behavior should be   Filter measure value  should display the "C/100" column value.  By default   Filter measure value  should display the "C/100" column value.