1_bit_wonder
New Member
- Joined
- Dec 31, 2024
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Im trying to filter a cubset based on a secondary column
I have a dataset with many columns but the 2 of interest or Company_Name (text) and Charity (yes/No)
i want to get a list of Company_Names that are charities so far i have
but when i try and get a count it comes back as 0 (Should be > 6)
If i take the filter and the charity line out i get the full list. Im close i just cant get past the finish line.
I'd appreciate any help
I have a dataset with many columns but the 2 of interest or Company_Name (text) and Charity (yes/No)
i want to get a list of Company_Names that are charities so far i have
Excel Formula:
=CUBESET(
"ThisWorkbookDataModel",
"FILTER(
[Base_Data].[Company_Name].children,
[Base_Data].[Charity].CURRENTMEMBER.MEMBER_VALUE = true
)",
"Filtered Company Names"
)
Excel Formula:
=CUBESETCOUNT(Q6)
If i take the filter and the charity line out i get the full list. Im close i just cant get past the finish line.
I'd appreciate any help