Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
jay3828
Frequent Visitor

count of of users by vendor for current day

Hello hacking my way through learning power bi.  I have a slider that is based on Vendors and a pie chart that I would like to provide the count of users that are related to a vendor where datetable_dim = today.  
so I am looking to create a measure that would count the number of users in the fact table related to the vendor when the date is = to today?  in sql this is simple. in dax it is braking my brain.  but I want to learn dax.
sample sql
select count(distinct rtt.username) as _cnt, fc.vendororganizationname as vendor
from CTX_SESSIONRTT_UTC rtt
inner join persona fc on lower(rtt.username) = lower(fc.domainuserid)
where rtt.sessionstartdate = current_date() and rtt.sessionstarttime is not null and rtt.sessionkey is not null
and length(fc.vendororganizationname) > 1
and length(rtt.username) > 1
and rtt.username is not null
group by vendor
order by vendor;
 layout.png

 

1 REPLY 1
v-binbinyu-msft
Community Support
Community Support

Hi @jay3828 ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

 

Best regards,
Community Support Team_Binbin Yu

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors