Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey
I Have the table
"FKProductionItemID" refers to a specific production item
"FKProductionsItemDataTypeID" referes to what DataType is submitted for the each productionItem
"ItemDataValue" refers to the value submitted for the specific production item and the specific Datatype.
I need to show all FKProductionItemID (table) with the ItemDataValue when the FKproductionItemTypeID is equal to 1.
And i need to filter it (slicer) on the ItemDataValue when the FKprodcutionItemTypeID is equal to 2.
I setup up a slicer with a filter on FKprodcutionItemTypeID = 2 but that filter also works on the table so the columns containing FKproductionItemTypeID is equal to 1 doesn't show up.
Solved! Go to Solution.
You may refer to the following post.
https://community.powerbi.com/t5/Desktop/Tricky-Slicer-Options/m-p/573381#M270846
Hi @Ratax
If you are looking to retrieve ItemDataValue for FKproductionItemTypeID = "1" while selecting FKproductionItemTypeID = "2" on the slicer, then you can use a expression like below.
Measure = VAR _type = VALUES( 'Table'[FKProductionItemID] ) RETURN CALCULATE( SUM( 'Table'[ItemDataValue] ), ALL( 'Table' ), TREATAS( _type, 'Table'[FKProductionItemID] ), 'Table'[FKProductionsItemDataTypeID] = "1" )
The slicer would looks like this.
I added ItemDataValue to the field in the slicer, and put a visual filter that filters FKProductionsItemData=2.
The table would look like this. It returns all the FKproductionItemID with ItemDataValues where FKproctionsDataTypeID =1.
You may refer to the following post.
https://community.powerbi.com/t5/Desktop/Tricky-Slicer-Options/m-p/573381#M270846
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |