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 all,
Need to automate the Filter section in DAX on the basis of selection in a particular field.
You need to make the selection in Testaname field.
Below is the data Set
ID | Employee ID | Employee Name | Employee Status |
1 | E1 | ABC | Active |
2 | E2 | CEF | Active |
3 | E3 | GHI | Active |
4 | E4 | JKL | Inactive |
5 | MNO | Active | |
6 | E6 | PQR | Active |
7 | E7 | Active | |
8 | E8 | VW | Active |
9 | E9 | XY | |
10 | E10 | Z | Active |
RowID | TestaName | Table Name | Field |
1 | Employee ID is Blank | Test Data | Employee ID |
2 | Employee Name is Blank | Test Data | Employee Name |
3 | Employee Status is Blank | Test Data | Employee Status |
When i do any selection in TestaName field it should return me the count of blank of that particulate column in the 1st table
Dax which i created and is not working
Hi @ppriya ,
Field parameters are recomended.
Please create three measures:
Employee ID is Blank = CALCULATE(COUNT('Table'[Employee ID]),FILTER('Table','Table'[Employee ID] = BLANK()))
Employee Name is Blank = CALCULATE(COUNT('Table'[Employee Name]),FILTER('Table','Table'[Employee Name] = BLANK()))
Employee Status is Blank = CALCULATE(COUNT('Table'[Employee Status]),FILTER('Table','Table'[Employee Status] = BLANK()))
Modeling - New parameter - Fields
Add fields:
Create a slicer:
Create a card visual:
You will get the count of blank of that particulate column in the 1st table :
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ppriya
Did I solve your problem? If solved, please consider Accept it as the solution to help the other members find it more quickly.
Best regards,
Yadong Fang
Kindly help with the issue .
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 |
---|---|
47 | |
22 | |
20 | |
15 | |
13 |
User | Count |
---|---|
49 | |
41 | |
39 | |
19 | |
19 |