Forum Discussion
Need Urgent Help Please
I am new to Dax and I need help please.
I have a table with Customer ID, and name etc
The table has a column called Contact Dates in DD/MM/YYYY format
and another column called Required Number of contacts.
There is a required number of visits that must be made to each customer and reported as timely or not timely.
IF the distinct count of visit => the required number of visits it qualifies as Timely, vice versa.
I have been able to create a measure using this DAX FORMULA
For example the table visual above has 5 records based on the selected slicers, but returns 6 records when I convert it into a card visual and applying countdistinct on the child id.
Please I need help as to how I can create a card visual that will return the same number of records as displayed on the tablke with the slicers selected
1 Reply
- Greg_DecklerCommunity Champion
Anonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.