The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello community
I would like to know if it is somehow possible to filter a table by using slicers from my model despite the table I am insterested does not have any relationship with the other existing tables.
Model is in the screenshot below, and the table I am interested to filter is the one called Threshold
My end result should be an analysis as follows but being able to filter by columns from the other tables.
Solved! Go to Solution.
Replace the Inv_Threshold and Value_Threshold calculated columns with measures, that way they will still respond to filters or slicers on the other tables, e.g.
Inv_Threshold = CALCULATE( COUNTROWS(T_RawData_Azure), T_RawData_Azure[Amount_in_EUR] <= SELECTEDVALUE( 'Thresholds'[Threshold]) )
Replace the Inv_Threshold and Value_Threshold calculated columns with measures, that way they will still respond to filters or slicers on the other tables, e.g.
Inv_Threshold = CALCULATE( COUNTROWS(T_RawData_Azure), T_RawData_Azure[Amount_in_EUR] <= SELECTEDVALUE( 'Thresholds'[Threshold]) )
Thanks (L)