The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
In power: when i use distinctcount or distinctcountnoblank functions then im getting the distinct count is 7 but in spotfire its 5 count.... could you please help on this please asap
spotfire CALS:
POWER BI DATA:
Solved! Go to Solution.
Hey @Anonymous ,
Do you have anything joined to the dataset? I'm showing 5 for the count on my end. Unless what you're saying is the total should be 7?
Proud to be a Super User!
Hey @Anonymous ,
Do you have anything joined to the dataset? I'm showing 5 for the count on my end. Unless what you're saying is the total should be 7?
Proud to be a Super User!
there is no joinig, only one table is present in power bi file
@Watsky I agreed with your results but in my power bi file its not showing it. In my power bi file its not coming correct count as you got it.
@Anonymous please provide sample data in table format here
I'm unable to attached the excel or csv file or pbix file here. im gettting below errors. could you please help me how to attach the files so that i would share with you
@Anonymous ,
Send the file to onedrive or google drive then post the link to it here.
Proud to be a Super User!
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |