Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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;
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