Sum only Values where another Column has Data
Harder than it looks: I have this simple table like below: I want to calculate how we're performing based on the goal in a Card. So I need to Sum only the goal values where the Gross Adds column is not blank(GAs are in the past and Goals are for the whole month). In theory this should work, but it puts a total for all the months previous rather than what is selected in the slicer. What's strange is if I replace [GAGoal] with [Gross Adds] in the measure below it correctly adds up the Gross Adds for the current month selected in the slicer. GoalTotalCurrent = VAR LastDaySelection = LASTNONBLANK ( 'Calendar'[Calendar Date], [Gross Adds] ) VAR CurrentRange = DATESBETWEEN ( 'Calendar'[Calendar Date], MIN ('Calendar'[Calendar Date] ), LastDaySelection ) RETURN IF ( LastDaySelection >= MIN ( 'Calendar'[Calendar Date]),CALCULATE ( [GAGoal], CurrentRange )) I've tried things like this, but it results in blank: SumGoals = IF(SUMX('Subscriber Activity',[Gross Adds])<>Blank(),SUMX('Subscriber Activity',[GAGoal])) So it shouldn't sum 1/8,1/9,or1/10 Date Goal Gross Adds 1/1/2025 5 6 1/2/2025 7 5 1/3/2025 8 7 1/4/2025 7 7 1/5/2025 4 3 1/6/2025 3 2 1/7/2025 2 1 1/8/2025 5 1/9/2025 5 1/10/2025 5
Weather Visual
Hello all! Hope you are all well and somebody out there can help me. I am currrently building a dashboard and would like to have the weather temprature showing on the "card" visual. any ideas how to make this work? I have had a look online and cant seem to come across anything. If you have a idea or any tips please let me know. Many thanks 🙂
RANKX & CARD
Hello, I have a dataset named "CollectionData". I will introduce you the columns in the table and the first 5 rows in these columns. Date EkipName CollectionSourceGroup CollectionTRY CurrentUPB 01.06.2020 Inbound Protocol 234234 44354 10.10.2021 Outbound Diger 34324 4534 17.03.2022 Diger Execution Office 342 3454 20.05.2022 Diger Salary Attachment 345 454 Toplam Tahsilat = SUM(CollectionData[CollectionTRY]) Toplam Anapara = SUM(CollectionData[CurrentUPB]) What I want to do is I split the "Toplam Tahsilat" and "Toplam Anapara" fields into each other. I sorted them by "EkipName" and "CollectionSourceName" columns, from largest to smallest. No problems so far. I am sharing the Measure below. SIRALAMA = IF( OR( HASONEFILTER(CollectionData[EkipName]), HASONEFILTER(CollectionData[CollectionSourceGroup]) ), RANKX( ALL(CollectionData[EkipName],CollectionData[CollectionSourceGroup]), DIVIDE([Toplam Tahsilat], [Toplam Anapara], 0) ) ) It should not be forgotten that there was also a "Date" field in Raw Data, but I removed the "Date" field in the table. So I changed the Context and sorted accordingly. But what I want to do is I want to show the value of "EkipName" as "Card" of the row with the largest order. I wrote the following DAX for this, but it doesn't work. Because the Context is different. ForCard = IF ( [SIRALAMA] = 1, MAXX ( FILTER ( CollectionData , [SIRALAMA] = 1 ), CollectionData[EkipName] ) ) Can anyone help? Thanks.Percentage of dashboard Card / Silcer filter results
Hello everyone, I need your help & advice - We have created a dashboard which does include a Slicer & Cards. We are looking to add another Card which will Illustrate the percentage of Outage Count when a single Year is selected within Slicer "Year"(see snap shot below) I am not suprise the DAX script created below does not work. Any help would be greatly appreciated. Percentage Count = SUM('MajorIncidentTickets_2022-23'[number]) /CALCULATE(SUM('MajorIncidentTickets_2022-23'[number]), FILTER(ALL('MajorIncidentTickets_2022-23'),'MajorIncidentTickets_2022-23'[problem_id]=SELECTEDVALUE('MajorIncidentTickets_2022-23[problem_id]))
One measure to display desired value on card
Hello everyone i have the pbxi file below: https://1drv.ms/u/s!Ag9tIyk2ofNRjkrl7o_3GnzH9bQW?e=y3s9iy i want to make one measure for current period and another measure for previous month period as in i want revenue,expense or any desired value inside one current measure which desplays it on my desire without having to create alot of measures like below: you can see my calculations so current value = var rev = calculation for rev var exp = calculation for expense var gross = rev - exp switch ( if i want my card on revenue, choose revenue calculation if i want expense on card choose expense calculation... i hope i was clear and didnt make you guys confused i reall appreciate the help from anyoneDate Filter of a Measure
I am hoping that someone can help me. I have written a measure to return the 12mma (12 month moving average) value which is in the images attached. The 12mma shows in two ways, on the card (circled in red) and on the graph as the light blue line. The measure works correctly as it shows on the graph (light blue line) correctly. If I specifically select a month on my graph it also shows the correct value in the card. However, the problem I am having is the value in the card is not showing the correct value for the most recent month if I do not select a specific month on my graph. I have tried: Relative date filter for last 1 calendar months (does not work and returns blank if I select any month other than the last month in the range) Tried the Top N filter for the Top 1 by first month. This does not work at all. Various forms of measures but been unsuccessful. Is there a way to write a new measure to determine the most recent value of my existing measure if I have not selected a specific month? If I have selected a specific month then just return the measured value (how it already works). Sorry if my explanation is confusing, happy to explain further if needed. I have attached images for reference. The first image shows when nothing is selected. The circled value in the card should be 4,744 (as shown in the second image when I selected March).
