Tableau formula to dax
I'm currently in the process of transitioning Tableau reports to Power BI, and I'm encountering challenges with converting certain Tableau formulas into DAX expressions. One formula in particular has me stumped, and I'm seeking assistance to translate it. The Tableau formula involves the use of the FIXED function, which I'm not familiar with, and I'm unsure how to replicate its functionality in DAX. Here's the Tableau formula: IF { FIXED [Sales Document]: COUNT( IF [OT RDD HDR Flag | T,F] = TRUE AND [IF RDD HDR Flag | T,F] = TRUE THEN [Sales Document] END ) } = {FIXED [Sales Document] : COUNTD([Sales Document Item])} THEN 1 ELSE 0 END Any guidance or assistance with this translation process would be greatly appreciated."
Employee Retention, Filtering Based on Job Title and Business Location
Hi everyone, Thanks to this group I managed to work on my dax to calculate retention % for the business. However, the problem that I'm experiencing is when I tried to filter my visualization based on Job Title or Business Unit code, my measure doesn't change in line with the filter. My aim is to see retention % based on different business units and job title's so we can identify possible challenges for retaining talent within the organization. Here is my DAX: Thank you so much for the support! Retention % = VAR _Previous12START = EOMONTH ( MAX ( 'Calendar'[Date] ), -13 ) + 1 VAR _Previous12END = EOMONTH ( MAX ( 'Calendar'[Date] ), -1 ) VAR _LEFT = CALCULATE ( COUNT ( 'Master Data'[Employee Code] ), FILTER ( ALL ( 'Master Data' ), 'Master Data'[Date Engaged] >= _Previous12START && 'Master Data'[Date Engaged] <= _Previous12END && 'Master Data'[Date of Resignation] >= _Previous12START && 'Master Data'[Date of Resignation] <= _Previous12END ) ) + 0 VAR _Total = CALCULATE ( COUNT ( 'Master Data'[Employee Code] ), FILTER ( ALL ( 'Master Data' ), 'Master Data'[Date Engaged] <= _Previous12END && OR ( 'Master Data'[Date of Resignation] >= _Previous12START, 'Master Data'[Date of Resignation] = BLANK () ) ) ) RETURN 1 - DIVIDE ( _LEFT, _Total ) This is how the visualization look like:How to calculate the difference between two rows of a single column in power BI
Hi, How to calculate the difference between buy and sell of a salesvalues coulmn based on country by converting to rows to column of buy_sell column . Input: Country category buy_sell salesvalues India A buy Null India A sell -75,500.00 USA B buy -60,095 USA B sell 70,901 AUS C buy 29,923 AUS C sell -3,260,307 AUS D buy -60,750.00 AUS D sell -1500 USA E buy 10 USA E sell 20 USA F buy -20000 USA F sell Null Expected Output: Thanks, SBC
