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.
Hi
I have a Data model of Employees, that is to be classified into Age Groups defined in a separate Dimension Table. I can calculate the Age group of the Employee from DOB. But I need to do distinctCount on EmployeeID in the Dimension Table ...bcoz I need to filter the Employee table on the value referred in Dim Age-group tbl.
I am using Calculate function in a Column added to the Dim Age-group table & using filter function in it for the Date conditions. This gives me the correct values. The only issue here is when I place a Slicer with some different Dimension. The values aren't getting filtered out as Calculate ignores Filter context.
Can you please help me How can I get the values filtered by Slicer also?
Thanks
Apoorv
Calculated columns get loaded at first load only.
They can't change with slicer selection.
if you want something dynamic, need to create measures.
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.
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 |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |