I see this issue only in Power BI Service and data gets refreshed (Manual) in Power BI Desktop without any issues.
I am using a Multi-row card with 3 calculated Measures in it. The dataset for this table looks like the sample below:
The column "No.ofInstitutes" is a Custom Column which has
= [4 Y Avg. Chng] > 5 and [Actu. 4 Y Avg] > 10
Only if it is, these columns are > 5 and > 10 it should be TRUE.
I have created Measure just to pick the value 'TRUE' from this Custom Column. Here is that one of the Measure where the values are fetched from two different columns.
TotalRowCount = COUNTROWS(FILTER('Table1', 'Table1'[Notable] = "No" && 'Table1'[No.ofInstitutes]="TRUE")) + 0
Is there anything wrong with this DAX?
Should I use a calculated Measure instead of Custom Column? If so, what should that be?
I believe, the Custom Column or the DAX Measure is not working properly to get the latest data in the Multi-row card visual in Power BI Service.
I should also say that, there are number of DAX Measures and visuals in this report and known has this issue (means all the latest data can been seen).
Appreciate your help!
What is your data source? If it is on-premise, did you add data source to Data Gateway? Besides, please test on service whether the result returned by measure is changed if using a common card visual to display data.
@v-yulgu-msft. Yes, the data source is added to the Gateway and it is On-Premise SQL Data Source. There are around 15 multi-row cards in that report along with other visuals but only one value (Measure) is showing 0 in the multi-row card.
Yes, I am testing with the common card visual.
Also, I deleted the existing dataset and the visual to recreate the same multi-row card visual again to see if this fixes the problem.
I wanted confirm if the method I used to create a custom column and then the DAX Measure is right or wrong since I am picking values from two different columns as FILTERS in DAX Measure?
I have another similar calculation and multi-row visual using the Custom column and DAX Measure but only difference is the FILTER (in DAX Measure) used is only one column.
Recreating the multi-row card and also trying a common card visual did not work again. When I publish for the first time, it shows the corret value, after the schedule refresh it turns 0.
Any idea why?