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.
I have the below calculated measure using a CrossFilter function as below. It is displayed on a card visual. It reduces the total number of rows (grants) correctly, and also updates based on other filters applied via slicers on the Power BI Page
AvailableCountOfGrants =
CALCULATE
( DISTINCTCOUNT(DimGrant[Grant_Id])
, CROSSFILTER
(
DimGrant[Grant_Id]
,'etl ChartOfAccounts'[Grant_Id]
, Both
)
, vwDimGrantActiveStatus[IsActive] = "Yes"
)
How can I apply the same filtering logic to display a list of filtered rows from DimGrant in a table visual? How can I convert the filtering logic in the measure to be used for filtering visuals. Also vwGrantActiveStatus and DimGrant are related 1 to 1
From within the modeling pane, I tried creating a New Table using CalculateTable and applying the cross filter logic but that did not work. When I was pulling data from such a calculated table, the other Page level filters were not being preserved. And I spent a lot of time looking at variations of using DAX filters like Related, KeepFilters, AllSelected, Filter, etc. Nothing works. I probably don't have the right approach at this since the goal is simply to created a filtered table visual using the same logic from the calculated measure.
Thank you much.
Solved! Go to Solution.
Ok found it. I just had to drag the count measure in the visual level filter for the table visualization and apply - Show items when the value is not blank
This reduced the number of rows correctly in the table viz in relation to chosen filters from other slicers. Yay.
Credit to this post for helping see that. https://community.powerbi.com/t5/Desktop/Include-a-measure-in-the-visual-level-filter/m-p/302518/hig...
Power BI Desktop forum is great! Thank you.
Ok found it. I just had to drag the count measure in the visual level filter for the table visualization and apply - Show items when the value is not blank
This reduced the number of rows correctly in the table viz in relation to chosen filters from other slicers. Yay.
Credit to this post for helping see that. https://community.powerbi.com/t5/Desktop/Include-a-measure-in-the-visual-level-filter/m-p/302518/hig...
Power BI Desktop forum is great! Thank you.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |