Hello,
How to create a variable in Qlik Sense report like this Dax queries(PowerBI) given below?
VAR Level_Check
CALCULATE(
COUNTROWS(
FILTER(DFS_NTFS,NOT(DFS_NTFS[rootFolder]))),
ALLEXCEPT(DFS_NTFS,DFS_NTFS[dfsFolder_id]))
VAR Accounts_countrows
CALCULATE(
COUNTROWS(DFS_NTFS),
FILTER(
ALLEXCEPT(DFS_NTFS,DFS_NTFS[dfsFolder_id]),
DFS_NTFS[Account.Check]<>"ADM_Built"))
VAR Admin_accounts
CALCULATE(
COUNTROWS(DFS_NTFS),
FILTER(
ALLEXCEPT(DFS_NTFS,DFS_NTFS[dfsFolder_id]),
DFS_NTFS[Permissions.Check]="Admin Full Control"&&
DFS_NTFS[isInherited]))