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 need help to find Active Clients which are not charged in particular week. i am attaching data and in data i have mentioned each table on separate sheet, Client sheet is for Client Table and Charge Sheet is for Charges table and 3rd sheet is for expected output.
Charges table only holds those clients which are charged.
Please see file here Click to download
Solved! Go to Solution.
@Anonymous
Try this MEASURE as a visual filter for Client Table.
Please see attached file as well
Measure = IF ( SELECTEDVALUE ( Client[Name] ) IN EXCEPT ( VALUES ( Client[Name] ), VALUES ( Charges[Client Name] ) ), 1, 0 )
@Anonymous
Try this MEASURE as a visual filter for Client Table.
Please see attached file as well
Measure = IF ( SELECTEDVALUE ( Client[Name] ) IN EXCEPT ( VALUES ( Client[Name] ), VALUES ( Charges[Client Name] ) ), 1, 0 )
Thanks Zubair, i am facing another issue with previous solution basically i also have start date in clinet table so i want to show only those records which have week of start date should be before or equal to week and year selected in slicer. @Zubair_Muhammad
Thank you this works like a charm.
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 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |