Forum Discussion

ukantkumar123's avatar
ukantkumar123
Frequent Visitor
2 years ago
Solved

Need to write a measure or custom column which will filter table data and show the count for same

DateCity NumberPlanned %Actual %
21-09-2023 00:00:003006561.190.69
28-09-2023 00:00:003006561.190.69
05-10-2023 00:00:003006560.810.7
21-09-2023 00:00:003006710.030.87
28-09-2023 00:00:003006710.021.34
05-10-2023 00:00:003006710.031.87
12-10-2023 00:00:003006710.030.88
19-10-2023 00:00:003006710.030.78
26-10-2023 00:00:003006710.031.06
02-11-2023 00:00:003006710.030.98
26-10-2023 00:00:003006721.020.05
02-11-2023 00:00:003006720.453.33
21-09-2023 00:00:003006843.372.82
28-09-2023 00:00:003006843.031.39
05-10-2023 00:00:003006843.261.59
12-10-2023 00:00:003006842.751.39
19-10-2023 00:00:003006842.811.48
26-10-2023 00:00:003006842.651.73
02-11-2023 00:00:003006842.731.62
21-09-2023 00:00:003006950.040.77
28-09-2023 00:00:003006950.030.35
05-10-2023 00:00:003006950.040.49
12-10-2023 00:00:003006950.040.32
19-10-2023 00:00:003006950.040.37
26-10-2023 00:00:003006950.040.41
02-11-2023 00:00:003006950.040.36
26-10-2023 00:00:003006960.590
02-11-2023 00:00:003006960.193.3
05-10-2023 00:00:003007110.040.17
12-10-2023 00:00:003007110.130.17
19-10-2023 00:00:003007110.230.28
26-10-2023 00:00:003007110.220.38
02-11-2023 00:00:003007110.430.5
19-10-2023 00:00:003007130.910.71
26-10-2023 00:00:003007131.440.69
02-11-2023 00:00:003007130.830.76
21-09-2023 00:00:003007202.390.66
28-09-2023 00:00:003007202.661.45
05-10-2023 00:00:003007205.430.29
12-10-2023 00:00:003007203.390.57
19-10-2023 00:00:003007203.690.53
26-10-2023 00:00:003007204.050.55
02-11-2023 00:00:003007205.830.91
21-09-2023 00:00:003007240.840.32
28-09-2023 00:00:003007240.890.45
05-10-2023 00:00:003007241.940.98
12-10-2023 00:00:003007242.391.19
19-10-2023 00:00:003007243.161.52
26-10-2023 00:00:003007242.791.58
02-11-2023 00:00:003007241.272.26
21-09-2023 00:00:003007312.322.41
28-09-2023 00:00:003007312.024.11
05-10-2023 00:00:003007312.233.22
12-10-2023 00:00:003007311.872.95
19-10-2023 00:00:003007311.443.46
26-10-2023 00:00:003007312.022.67
02-11-2023 00:00:003007312.043.44

Planned % cumm = CALCULATE(SUM('Variance Test  Data'[Planned %]),FILTER(ALLEXCEPT('Variance Test  Data','Variance Test  Data'[City Number]),'Variance Test  Data'[Date]<=MAX('Variance Test  Data'[Date])))
 
Actaul % cumm = CALCULATE(SUM('Variance Test  Data'[Actual %]),FILTER(ALLEXCEPT('Variance Test  Data','Variance Test  Data'[City Number]),'Variance Test  Data'[Date]<=MAX('Variance Test  Data'[Date])))
 
Var% = 'Variance Test  Data'[Actaul % cumm]-'Variance Test  Data'[Planned % cumm]
 
 

Need one card Value which show count of Variance(Var%) lie inside the range of -5% to -25%.Also i need one button for same which will filter table data (Based on max date selection and "Var%" lie in to -5% to -25% )

Need Help

10 Replies

      • ukantkumar123's avatar
        ukantkumar123
        Frequent Visitor
        2 years ago

        Thanks for reply lbendlin 

         

        I need total count on card along with slicer (Slicer shoud filter table data)

         

         

  • ukantkumar123's avatar
    ukantkumar123
    Frequent Visitor
    2 years ago

    lbendlin Now I need one slicer or button if click on it it shord show filter all the data in table and show only same which is satisfying the condition in table

     

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      You can add that slicer yourself. What column should it be on?

      • ukantkumar123's avatar
        ukantkumar123
        Frequent Visitor
        2 years ago

        lbendlin Ashish_Mathur 

        Reg :My End Goal is to Fiter the metadata in table using Slicer.

        Challenge:

        My end goal is to dynamically filter metadata in a table based on specific conditions, and we have created a measure for this purpose. However, I am looking for an effective way to enable users to interact with this measure and filter the data accordingly.

         

        Request for Guidance: I would greatly appreciate your insights on the best approach to achieve this. Are there alternative methods or best practices you could recommend for allowing users to filter metadata in a table using measures in Power BI?

        I value your expertise and would be grateful for any guidance you can provide to help me overcome this challenge. If you have some time, could we schedule a brief meeting to discuss this in more detail?

        Thank you in advance for your assistance, and I look forward to hearing from you.